Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Here's the work I did in excel. my numbers aren't working for B & C. Sales 2601.5 Costs -1560.9 Interest -34 Pre-tax profit 1006.6 Tax

image text in transcribed

Here's the work I did in excel. my numbers aren't working for B & C.

Sales 2601.5
Costs -1560.9
Interest -34
Pre-tax profit 1006.6
Tax -402.64
Net Income 603.96
Less: Dividend paid @50% of net income -301.98
Net income available to shareholders 301.98
Assets 5060 Debt 680
Equity 3720
Net income 301.98
New equity to be issued 358.02
Total 5060 5060
The following tables summarizes the 2019 income statement and end-year balance sheet of Drake's Bowling Alleys. Drake's financial manager forecasts a 10% increase in sales and costs in 2020. The ratio of sales to average assets is expected to remain at 0.55. Interest is forecasted at 5% of debt at the start of the year. Sales Costs Interest Pretax profit Tax Net income INCOME STATEMENT, 2019 (Figures in $ thousands) $ 2,365 (55% of average assets) 1,419 (60% of sales) 34 (5% of debt at start of year) $ 912 365 (40% of pretax profit) 547 $ a Assets at the end of 2018 were $4,200,000. b Debt at the end of 2018 was $680,000. Assets BALANCE SHEET, YEAR-END (Figures in $ thousands) $ 4,400 Debt Equity $ 4,400 $ 680 3,720 $4,400 Total a. What is the implied level of assets at the end of 2020? (Do not round your intermediate calculations. Enter your answer in thousands.) b. If the company pays out 50% of net income as dividends, how much cash will Drake's need to raise in the capital markets in 2020? (Do not round your intermediate calculations. Enter your answer in thousands.) c. If Drake's is unwilling to make an equity issue, what will be the debt ratio at the end of 2020? (Do not round your intermediate calculations. Round your answer to 2 decimal places.) $ 5,060 a. Implied level of assets b. Additional cash Debt ratio C

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

Balancing Acts Unleashing The Power Of Creativity In Your Life And Work

Authors: Daniel Lamarre

1st Edition

1400223024, 978-1400223022

More Books

Students also viewed these Finance questions