Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Based on the below presented forecast please prepare estimation of financial reports and answer following questions: How much external capital is needed to keep end

Based on the below presented forecast please prepare estimation of financial reports and answer following questions:

  • How much external capital is needed to keep end of year cash on the level of 1 500. If there is no need for external capital, please calculate how much dividends can be paid by the company in subsequent years (to answer the question please prepare forecasted P&L, Cash Flow Statements and Balance Sheets ?.

  • Please calculate FCFF & FCFE using formulas ?

  • What is the value of one share assuming that the WACC of the company equals 11% and after the year 2024 there will be no growth of FCFF (g=0). The company issued 1000 shares .

Balance Sheet

Assets

2020

Fixed assets

11 233

Current assets

17 466

Inventories

10 000

Accounts receivable

1 222

Cash

6 244

TOTAL 699

Liabilities and equity

2020

Stockholder's equity

17 554

Common stock

15 000

Capital surplus / Accum. Retain earning

1 233

Net incom

1 321

Liabilities

11 145

Long-term debt

10 000

Accounts payable

1 145

Total liabilities and stockholder's equity 28 699

Forecast

2021F

2022F

2023F

2024F

Planned operating revenues

20 000

25 000

25 000

30 000

Cost of goods sold

8 000

10 000

10 000

12 000

Selling costs

1 600

2 000

2 000

2 200

Accounts payable (expected closing balance)

2 000

2 200

2 250

2 300

Planned account receivable ratio in days

30

30

30

30

Planned inventories as % of revenue

5%

6%

5%

5%

Acquisition of fixed assets

11 000

5 000

5 000

3 000

Proceeds from new long-term debt

2 500

2 500

Repayment of debt (includes notes)

2 500

2 500

2 500

2 500

Proceeds from new stock issue

Dividends

1 000

1 000

1 000

1 000

General, and administrative expenses

4 400

4 700

4 700

4 700

Other income

1 220

Depreciation

2 000

5 000

4 000

3 000

Interest expense

600

500

400

300

Tax rate

20%

20%

20%

20%

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

Personal Finance

Authors: Jeff Madura

3rd Edition

0321357973, 978-0321357977

More Books

Students also viewed these Finance questions