Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

solve in excel The most recent financial statements for Scott, Inc., appear below. Sales for 2020 are projected to grow by 30 percent. Interest expense

solve in excel

image text in transcribed

The most recent financial statements for Scott, Inc., appear below. Sales for 2020 are projected to grow by 30 percent. Interest expense will remain constant; the tax rate and the dividend payout rate also will remain constant. Costs, other expenses, current assets, fixed assets, and accounts payable increase spontaneously with sales. SCOTT, INC. 2019 Income Statement Sales Costs Other expenses $746,000 581,000 17,000 $ 148,000 Earnings before interest and taxes Interest expense 13,000 Taxable income Taxes (23%) $ 135,000 31,050 Net income $ 103,950 $ 31,185 Dividends Addition to retained earnings 72,765 SCOTT, INC Balance Sheet as of December 31, 2019 Assets Liabilities and Owners' Equity Current assets Current liabilities Cash $ 20,540 Accounts payable $ 54,700 Accounts receivable 43,480 Notes payable 13.900 Inventory 90,960 Total $ 68,600 Total $ 154,980 Long-term debt $ 129,000 Fixed assets Net plant and equipment $422,000 Owners' equity Common stock and paid-in surplus Retained earnings $ 114,000 265,380 Total $379,380 Total assets $576,980 Total liabilities and owners equity $576,980 If the firm is operating at full capacity and no new debt or equity is issued, what external financing is needed to support the 30 percent growth rate in sales? (Do not round intermediate calculations.) EFN

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

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

Financial Analysis And Modeling Using Excel And VBA

Authors: Chandan Sengupta

2nd Edition

047027560X, 978-0470275603

More Books

Students also viewed these Finance questions

Question

12. What has been the best piece of advice that youve been given?

Answered: 1 week ago