Category Prior year Current year Accounts payable 41,400 45,000 Accounts receivable 115,200 122,400 Accruals 16,200 13,500 Additional paid in capital 200,000 216,660

Balance Sheet December 31 Assets Cash Inventory Equipment Accounts receivable Less: Accumulated depreciation $ 21,000 520,000 142,500 $ 624,000 78,000 546,000 Total assets $ 1,229,500 Liabilities and Equity Liabilities Accounts payable Loan payable Taxes payable (due March 15) $ 355,000 11,000 88,000 454,000 Equity Common stock Retained earnings $ 474,500 301,000 775,500 Total liabilities and equity $ 1,229,500 To prepare a master budget for January, February, and March, use the following information. a. The company's single product is purchased for $30 per unit and resold for $58 per unit. The inventory level of 4,750 units on December 31 is more than management's desired level, which is 20% of the next month's budgeted sales units. Budgeted sales are January, 6,500 units; February, 9,000 units; March, 11,000 units; and April, 10,000 units. All sales are on credit. b. Cash receipts from sales are budgeted as follows: January, $233,100; February, $722,857; March, $519,245. c. Cash…

Aa.1

Year Net Cash Flow Discount Factor Present Value (using the factor) Present Value (using Excel formula) 0 $ (3,500,000.00) 1 $(3,500,000.00) ($3,500,000.00) 1 $900,000.00 0.90909 $818, 181.00 $818, 181.82 2 $ 900,000.00 0.82645 $743,805.00 $743, 801.65 3 $900,000.00 0.75131 $676, 179.00 $676, 183.32 4 $ 900,000.00 0.68301 $614,709.00 $614,712.11 5 $900,000.00 0.62092 $558, 828.00 $558,829.19 Net Present Value $(88,298.00) $(88,291.91) 3. Now assume that inflation is estimated as a 5% increase each year (starting with Year 1) for the entire 5 years. Calculate the new net cash flow values for each year. Hint: You should start with 5% increase for Year 1 net cash flow.