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 to Expert-Tailored Solutions

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

Step: 2

blur-text-image_2

Step: 3

blur-text-image_3

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

The Financial Numbers Game

Authors: Charles W Mulford, Eugene E Comiskey

1st Edition

0471770736, 9780471770732

More Books

Students also viewed these Accounting questions

Question

Speak clearly and distinctly with moderate energy

Answered: 1 week ago

Question

Get married, do not wait for me

Answered: 1 week ago

Question

Do not pay him, wait until I come

Answered: 1 week ago