Please help me understand hot to set this up in Excel to obtain


Question Description:

35

Please help me understand hot to set this up in Excel to obtain the answer for additional funds needed. I would like to adjust the % RR Company.xlsx December Balance Sheet Cash Accounts receivable Inventories Net fixed assets Total assets $100 $200 $200 $500 $1,000 Additional Funds Needed The RR companies sales are forecasted to double from $1,000 in 2012 to $2,000 in 2013. Here is the December 31, 2012, balance sheet: Accounts payable Notes payable Accruals Long-term debt Common stock Retained earnings Total liabilities and equity $50 $150 $50 $400 $100 $250 $1,000 What is RR additional funds needed (AFN) for the coming year? Round your answer to the nearest dollar. The RR companies fixed assets were used to only 50% of capacity during 2012, but its current assets were at their proper levels in relation to sales. Spontaneous liabilities and all assets except fixed assets must increase at the same rate as sales, and fixed assets would also have to increase at the same rate f the current excess capacity did not exist. RR after-tax profit margin is forecasted to be 8% and its payout ratio to be 55%. Read more

Answer

35