Prepare the pro forma balance sheet for years

Assignment Help Accounting Basics
Reference no: EM131693589

Question - Master Chemicals is planning its financing needs for the next 5 years. The balance sheet for the year 2015 and 2016 and the income statement for the year 2016 are as shown below:

 

2016

2015

Net working capital

190

140

Fixed Assets:

 

 

Gross Fixed Assets

350

  

320

Less accumulated depreciation

100

80

Net Fixed Assets

250

  

240

Total Net Assets

440

380

 

  

 

Long term debt

90

60

Net worth (Paid up capital plus retained earnings)

 

350

320

Long term Liabilities and Net Worth

 440

380

 

2016

Revenues

2200.00

Costs

2055.00

 

Depreciation

20.00

 

EBIT

125.00

Interest

5.00

 

Tax

60.00

Net Income

60.00

 

The manager has forecast the following:

The sales are expected to increase by 20% every year for years 2017, 2018, 2019, 2020 and 2021

The costs will be 92% of the revenue

Depreciation will be 9% of net fixed assets at start of the year

Dividend will be 60% of net income

Net working capital will be 11% of revenues

Investment in net fixed assets will be 12.5% of revenues

Tax rate is 50%

All additional capital needed will be financed through debt

Interest will be charged at 10% of long term debt at the beginning of the year

(a) Prepare the Pro forma income statement for years 2017 to 2021.

(b) Estimate the additional financing required for each of the 5 years.

(c) Prepare the Pro forma balance sheet for years 2017 to 2021.

Reference no: EM131693589

Questions Cloud

Pourbaix diagrams for nickel and silver : Draw another diagram overlaying the Pourbaix diagrams for nickel and silver and Use this diagram to explain the likely outcome of holding a solution
What are the elements of a legal contract : What are the elements of a legal contract? What form can or must a contract take? Can a contract be modified? What are the methods of discharging a contract?
Calculate cost of one unit of product under variable costing : Income Statements under Absorption and Variable Costing In the coming year, Imre Company expects to sell 56,900 units at $26 each.
Empirical literature and identify its target population : Locate a study reported in the empirical literature, and identify its target population, sampling frame, and sample
Prepare the pro forma balance sheet for years : Master Chemicals is planning its financing needs for the next 5 years. Prepare the Pro forma balance sheet for years 2017 to 2021
Post an explanation of the role that us national goals play : Post an explanation of the role that U.S. national (Healthy People 2020) and international (UN Sustainable Developmental Goals) goals
Total carrying cost of beta per year under the eoq policy : EOQ, Ordering Cost, Carrying Cost, and Total Inventory-Related Cost Refer to the data for Zellen Company.
What is the equity value of hgc : You determine that an approriate rate of return for HGC is 12.5%. If HGC has 100 million shares outstanding, what is the Equity Value of HGC?
Ethics is not following culturally accepted norms : "What Ethics is Not, " you read the statement "Ethics is not following culturally accepted norms.

Reviews

Write a Review

Accounting Basics Questions & Answers

  How much control does fed have over this longer real rate

Hubbard argues that the Fed can control the Fed funds rate, but the interest rate that is important for the economy is a longer-term real rate of interest.   How much control does the Fed have over this longer real rate?

  Coures:- fundamental accounting principles

Coures:- Fundamental Accounting Principles: - Explain the goals and uses of special journals.

  Accounting problems

Accounting problems,  Draw a detailed timeline incorporating the dividends, calculate    the exact Payback Period  b)   the discounted Payback Period. the IRR,  the NPV, the Profitability Index.

  Write a report on internal controls

Write a report on Internal Controls

  Prepare the bank reconciliation for company

Prepare the bank reconciliation for company.

  Cost-benefit analysis

Create a cost-benefit analysis to evaluate the project

  Theory of interest

Theory of Interest: NPV, IRR, Nominal and Real, Amortization, Sinking Fund, TWRR, DWRR

  Liquidity and profitability

Distinguish between liquidity and profitability.

  What is the expected risk premium on the portfolio

Your Corp, Inc. has a corporate tax rate of 35%. Please calculate their after tax cost of debt expressed as a percentage. Your Corp, Inc. has several outstanding bond issues all of which require semiannual interest payments.

  Simple interest and compound interest

Simple Interest, Compound interest, discount rate, force of interest, AV, PV

  Capm and venture capital

CAPM and Venture Capital

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd