posted a question
Need to use excel to calculate additional funds needed from the given balance sheet. --- A firm has the following balance sheet: Cash $20 Accounts payable $20 Accounts receivable $20 Notes payable $40 Inventory $20 Long term debt $80 Fixed assets $180 Common Stock $80 Retained earnings $20 Total assets $240 Total liabilities & Equity $240 Sales for the year just ended were $400, fixed assets were used a 80 percent of capacity. Current assets and accounts payable vary directly with sales. Sales are expected to grow by 5 percent next year, the expected net profit margin is 5 percent, and the dividend payout ratio is 60 percent. How much additional funds (AFN) will be needed next year, if any? ---