Answered step by step
Verified Expert Solution
Question
1 Approved Answer
a. Suppose 2014 sales are projected to increase by 15% over 2013 sales. Use the forecasted financial statement method to forecast a balance sheet and
a. Suppose 2014 sales are projected to increase by 15% over 2013 sales. Use the forecasted financial statement method to forecast a balance sheet and income statement for December 31, 2014. The interest rate on all debt is 10%, and cash earns no interest income. Assume that all additional debt in the form of a line of credit is added at the end of the year, which means that you should base the forecasted interest expense on the balance of debt at the beginning of the year. Use the forecasted income statement to determine the addition to retained earnings. Assume that the company was operating at full capacity in 2013, that it cannot selloff any of its fixed assets, and that any required financing will be borrowed as notes payable. Also, assume that assets, spontaneous liabilities, and operating costs are expected to increase by the same percentage as sales. Determine the additional funds needed. 22:3? Pro Forma after December 2013 2014 Sales Additions Pro Forma Financing Financing Cash $ 1,030.00 0.03 $ 1,242.00 $ 1,242.00 Accts Receivable $ 6,430.00 0.1883 $ 7,452.00 $ 2,452.00 Inventories $ 9,000.00 0.2005 $10,350.00 5 10,350.00 Total Curr. Assets $16,560.00 $19,044.00 $ 19,044.00 Fixed Assets $12,600.00 0.35 $14,490.00 $ 14,490.00 Total Assets $29,160.00 $33,534.00 $ 33,534.00 Ace. Payable 5 4,320.00 0.12 5 4,963.00 5 4,968.00 Accruals $ 2,830.00 0.08 $ 3,312.00 $ 3,312.00 Notes Payable $ 2,100.00 $ 2,100.00 $2,123.00 5 4,3.00 Total Curr. Liabilities $ 9,300.00 $10,380.00 $ 12,508.00 Long-term debt 5 3,500.00 5 3,500.00 $ 3,500.00 Total Debt $12,300.00 $13,330.00 5 16313.00 Common Stock $ 3,500.00 $ 3,500.01 $ 3,500.00 Retained Earnings $12,360.00 1.166\" $14,026.00 $ 14,026.00 Total liabilities and Eq. $29,160.00 $31,406.00 $ 33,534.00 AFN= $ 2,123.00
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access with AI-Powered Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started