Preview

Finance: Planning and Forecasting

Good Essays
Open Document
Open Document
1290 Words
Grammar
Grammar
Plagiarism
Plagiarism
Writing
Writing
Score
Score
Finance: Planning and Forecasting
PROBLEMS

Carter Corporation’s sales are expected to increase from $5 million in 2006 to
$6 million in 2007 or by 20 percent. Its assets totaled $3 million at the end of
2006. Carter is at full capacity, so its assets must grow at the same rate as projected sales. At the end of 2006, current liabilities were $1 million, consisting of $250,000 of accounts payable, $500,000 of notes payable, and $250,000 of accruals. The after-tax profit margin is forecasted to be 5 percent, and the forecasted payout ratio is 70 percent. Use this information to answer Problems 9-1, 9-2, and 9-3.

9-1 Use the AFN formula to forecast Carter’s additional funds needed for the
AFN Formula coming year.

9-2 What would be the additional funds needed if the company’s year-end 2006 assets
AFN Formula had been $4 million? Assume that all other numbers are the same. Why is this AFN different from the one you found in Problem 9-1? Is the company’s “capital intensity” the same or different?

9-3 Return to the assumption that the company had $3 million in assets at the end of
AFN Formula
2006, but now assume that the company pays no dividends. Under these assump- tions, what would be the additional funds needed for the coming year? Why is this AFN different from the one you found in Problem 9-1?

9-1 AFN = (A*/S0)∆S - (L*/S0)∆S - MS1(1 - d) = $1,000,000 - $1,000,000 - 0.05($6,000,000)(1 - 0.7) = (0.6)($1,000,000) - (0.1)($1,000,000) - ($300,000)(0.3) = $600,000 - $100,000 - $90,000 = $410,000.

9-2 AFN = $1,000,000 – (0.1)($1,000,000) – ($300,000)(0.3) = (0.8)($1,000,000) - $100,000 - $90,000 = $800,000 - $190,000 = $610,000.

The capital intensity ratio is measured as A*/S0. This firm’s capital intensity ratio is higher than that of the firm in Problem 14-1; therefore, this firm is more capital intensive--it would require a large increase in total assets to

You May Also Find These Documents Helpful

  • Better Essays

    The focus of EEC’s investment of the purchasing of the supplier is to cut down on the cost expenditures of the company. The primary board members and investors anticipate in the timeframe the fifth of to save financially in revenue $600,000 per annum this will accumulate $9 million in net in the timeframe of that 15 years. 14% of that investment and consumption cost will be attributed out of $9 million net, which adds up to sum of $3 million. The president of the company asked me to give an analysis in the possibilities foreseen in the investment what would be the Net Present Value, along with the Internal Rate of Return, and the payback of the investment.…

    • 1228 Words
    • 4 Pages
    Better Essays
  • Satisfactory Essays

    Fin 516 Week 1 Homework

    • 306 Words
    • 2 Pages

    The company will have to raise at least $42,000,000 if it invests in this capital project. 35% debt level x 12,000,000 capital budget = $42,000,000.…

    • 306 Words
    • 2 Pages
    Satisfactory Essays
  • Satisfactory Essays

    96 Balance Sheet 2004 2003 Edwards, Inc. has prepared the following comparative balance sheets Cash $198,000 $102,000 for 2003 and 2004: Receivables $106,000 $78,000 2004 2003 Inventory $100,000 $120,000 Prepaid expenses $12,000 $18,000 Cash $ 198,000 $102,000 Plant assets $840,000 $700,000 Receivables 106,000 78,000 Accumulated depreciation $(300,000) $(250,000) Inventory 100,000 120,000 Patent $102,000 $116,000 Prepaid expenses 12,000 18,000 $1,058,000 $884,000 Plant assets 840,000 700,000 Accounts payable $102,000 $112,000 Accumulated depreciation (300,000) (250,000) Accrued liabilities $40,000 $28,000 Patent 102,000 116,000 Mortgage payable $- $300,000 Preferred…

    • 522 Words
    • 3 Pages
    Satisfactory Essays
  • Satisfactory Essays

    depreciation 140,000 260,000 469,000 Intangible assets Patents—at cost less amortization 36,000 Total assets $1,354,200 PROBLEM 5-3 (Continued) Liabilities and Stockholders’ Equity Current liabilities Notes payable, secured by investments of $120,000 $ 94,000 Accounts due 148,000 Accrued expenditures 49,200 Total existing debts $ 291,200 Long-term liabilities 8% bonds payable, due January 1, 2018 400,000 Less: Unamortized discount on bonds due 20,000 380,000 Total debts 671,200 Stockholders’ equity Common stock Authorized 600,000 shares of $1 par value; issued and outstanding, 500,000 shares $500,000 Premium on common stock 45,000 545,000 Saved income 138,000 683,000 Total debts and stockholders’ equity $1,354,200 30 Points CA 24-2 Item 1…

    • 807 Words
    • 6 Pages
    Satisfactory Essays
  • Satisfactory Essays

    Finance 3301 questions

    • 326 Words
    • 2 Pages

    Broussard Skateboard’s sales are expected to increase by 15% from $8 million in 2012 to $9.2 million in 2013. Its assets totaled $5 million at the end of 2012. Broussard is already at full capacity, so its assets must grow at the same rate as projected sales. At the end of 2012, current liabilities were $1.4 million, consisting of $450,000 of accounts payable, $500,000 of notes payable, and $450,000 of accruals. The after-tax profit margin is forecasted to be 6%, and the forecasted payout ratio is 40%. Use the AFN equation to forecast Brous- sard’s additional funds needed for the coming year.…

    • 326 Words
    • 2 Pages
    Satisfactory Essays
  • Satisfactory Essays

    4) A firm has $500 million in revenue and explicit costs of $200 million per year. Its…

    • 2070 Words
    • 16 Pages
    Satisfactory Essays
  • Satisfactory Essays

    Ac 556 Week 4 Assingment

    • 470 Words
    • 2 Pages

    Expense | 12,000 | | | | | | | | | | | | | | | | | Annual after tax cash inflows | $22,725 | | | | | | | | | | | | | | | | | | | | | | | | | 3. Payback based upon initial cash outflows | | | | | | | | Initial investment | $80,000 | | | | | | | | Increase in WC | $20,000 | | | | | | | | | | | | | | | | | Initial cash outflows | $100,000 | | | | | | | | | | | | | | | | | Annual after tax cash inflows | $22,725 | | | | | | | | | | | | | | | | | Payback | 4.4 | years | | | | | | | | | | | | | | | | | | | | | | | | 4. Discounted payback based upon initial cash outflows | | | | | | | | | | | | | | | | | Annual cash inflows | 14% PV factor | Discounted cash flows | | Balance of initial investment | Discounted payback |…

    • 470 Words
    • 2 Pages
    Satisfactory Essays
  • Satisfactory Essays

    Vertical analysis in 2005 rounded up to 1% with 4,701 in cash and assets of 29,427…

    • 292 Words
    • 2 Pages
    Satisfactory Essays
  • Powerful Essays

    Uhura Company

    • 798 Words
    • 4 Pages

    InstructionsPrepare a revised balance sheet given the available information. Assume that the accumulated depreciation balance for the buildings is $160,000 and for the office equipment, $105,000. The allowance for doubtful accounts has a balance of $17,000. The pension obligation is considered a long-term liability.…

    • 798 Words
    • 4 Pages
    Powerful Essays
  • Satisfactory Essays

    Complete the horizontal analysis of the balance sheet data for Nike using 2006 as a base. (If amount decreases, use either a negative sign preceding the number, e.g. -45 or parenthesis, e.g. (45). Round all percentages to 1 decimal place, e.g. 12.5.)…

    • 871 Words
    • 4 Pages
    Satisfactory Essays
  • Satisfactory Essays

    3. How much cash and cash equivalents did the company have at the end of its most recent annual reporting period?…

    • 616 Words
    • 9 Pages
    Satisfactory Essays
  • Satisfactory Essays

    WEEK THREE LEARNING TEAM B ASSIGNMENT PROBLEM 1-30A OSHEA ENTERPRISES INCOME STATEMENT AT DECEMBER 31, 2002 REVENUE $48,000.00 OPERATING EXPENSES 32,000.00 NET INCOME (change in Net Assets) $16,000.00 OSHEA ENTERPRISES STATEMENT OF CHANGES IN STOCKHOLDERS EQUITY AT DECEMBER 31, 2002 BEGINNING COMMON STOCK 4,000.00 PLUS: COMMON STOCK ISSUED 10,000.00 ENDING COMMON STOCK $14,000.00 BEGINNING RETAINED EARNINGS 8,000.00 PLUS: NET INCOME 16,000.00 LESS: DIVIDENDS (2,000.00) ENDING RETAINED EARNINGS 22,000.00 TOTAL STOCKHOLDERS EQUITY $36,000.00 OSHEA ENTERPRISES BALANCE SHEET AT DECEMBER 31, 2002 ASSETS CASH $48,000.00 LAND TOTAL ASSETS $48,000.00 LIABILITIES NOTES PAYABLE $12,000.00 STOCKHOLDERS EQUITY COMMON STOCK $14,000.00 RETAINED EARNINGS 22,000.00 TOTAL STOCKHOLDERS EQUITY 36,000.00 TOTAL LIABILITY AND STOCKHOLDERS EQUITY $48,000.00 OSHEA ENTERPRISES STATEMENT OF CASH FLOWS AT DECEMBER 31, 2002 CASH FLOWS FROM OPERATING ACTIVITIES: CASH RECEIPTS FROM REVENUE $48,000.00 CASH PAYMENTS FOR EXPENSES (32,000.00) NET CASH FLOW FROM OPERATING EXPENSES $16,000.00 CASH FLOWS FOR INVESTING ACTIVITIES: CASH PAYMENTS TO PURCHASE LAND CASH FLOWS FROM FINANCING ACTIVITIES: CASH RECEIPTS FROM ISSUING COMMON STOCK 10,000.00 CASH PAYMENTS FOR DIVIDENDS (2,000.00) CASH PAYMENTS TO REDUCE LIABILITY (6,000.00) NET CASH…

    • 267 Words
    • 2 Pages
    Satisfactory Essays
  • Satisfactory Essays

    The auditor can use this form to document the performance and evaluation of ratio analysis in connection with analytical procedures performed in an audit. The form is only a guide and is not a substitute for professional judgment. The form may be modified by adding or omitting certain ratio analysis.…

    • 833 Words
    • 4 Pages
    Satisfactory Essays
  • Good Essays

    • The investments given in the case (Table A) fail to include estimates of cash and accounts receivable. Table F provides an estimate of the percentage of total assets needed at 16.3% $1,589,000 / (1-.163) = $1,898,447…

    • 580 Words
    • 3 Pages
    Good Essays
  • Powerful Essays

    B. The government would be interested in this forecast for many reasons. By forecasting the civilian unemployment rate, the government can have an idea of how stable the economy will be in the upcoming years.…

    • 3798 Words
    • 16 Pages
    Powerful Essays