Answered step by step
Verified Expert Solution
Link Copied!

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

image text in transcribed
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

blur-text-image

Get Instant Access with AI-Powered Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Mathematical Statistics With Applications In R

Authors: Chris P. Tsokos, K.M. Ramachandran

2nd Edition

124171133, 978-0124171138

Students also viewed these Accounting questions