Create the pro forma income statement

Assignment Help Financial Management
Reference no: EM131190932

Mike's Place

Assets 2013 2014 Liabilities & Owners Equity 2013 2014

Current Assets Cash 815 906 Current Liabilities Account Payable 983 1292

Notes Payables 720 840

Accounts Receivables 2405 2510 Other 105 188

Inventory 4608 4906 Total CL 1808 2320

Total Cash 7828 8322 Long term Debt 4817 4960

Fixed Assets Owner's Equity

Common Stock 10000 10000

Net PPE 15164 19167

Total Assets 22992 27489 Retained Earnings 6367 10209

Total OE    16367 20209

Total Liabilities & OE 22992 27489

Income Statement 2014

Sales 33500

Cost of Goods Sold 18970

Depreciation 1980

EBIT 12550

Int 486

EBT 12064

Taxes 4222

NI 7842

A. Suppose Mick's is projecting a 20% increase in sales for the coming year, and that cost of goods sold and all expenses remain a constant percentage of sales. Also assume that the amount of depreciation and interest paid and the firm's tax rate (35%) remain unchanged, Create the Pro Forma Income statement for 2055. Assume the firm's dividend payout is 50%. What will the firm pay out in dividends in 2015.

B. Assume all information given in part A. Also, assume all assets and current liabilities are proportional to sales but notes payable, long-term debt and common stock are not proportional to sales. If the firm's tax rate remains unchanged, the dividend payout is 55% what is the external financing needed (EFN) for 2015? Create the Pro Forma Balance Sheet for 2015?

C. Given the information in part A & B. If the firm is only operating at 82% of capacity, what are the full capacitiy sales and what is the external financing needed (EFN) for 2005?

Reference no: EM131190932

Questions Cloud

Bonds make semianual payments : Wathers Umbrella Corp. issues 15 years bonds 2 years ago at coupon rate of 7.8%. The bonds make semianual payments. If these bonds currently sell for 105% of par value, what is the YTM?
Develop list of practices for managing security governance : Develop a list of at least five best practices for implementing and managing an information security governance program within an organization.
What is the intrinsic value of the stock : You are valuing the stock price of a public company. The company pays annual dividend. This year the company issues dividend of $0.7 per share. The analysts consider the company grows at a constant rate of 5%. The required return is 7%. What is the i..
How does one become a forensic psychologist : What are some of the differences between psychology and the law that make the intersection challenging? Describe some of the major methods of forensic assessment. Who are forensic psychologists treating?
Create the pro forma income statement : Suppose Mick's is projecting a 20% increase in sales for the coming year, and that cost of goods sold and all expenses remain a constant percentage of sales. Also assume that the amount of depreciation and interest paid and the firm's tax rate (35%) ..
What is targets capital budgeting process : What is Target's capital budgeting process? Is it consistent with the company's business and financial objectives - Explain what the dashboards tell you as a manger. Isn't the NPV enough information for you to make a go/no-go decision?
Who was considered the first programmer : Describe Babbage's contribution to the history of computers.Who was considered the first programmer? Describe her contributions to the history of computers
Total after tax cash flow that will result from selling : Net income is 1,012. Interest expense totals 266, while EBITDA is 2,584. If taxes are 633, what is depreciation and amortization (DA) ? A business purchases depreciable equipment for 198, and sells it a few years later for 140. At the time of the sal..
Discuss the authors summary about the validity : Describe the sample, demographics, data collection process, setting, and the instrument, tool, or survey used in the articles. Discuss the authors' summary about the validity and reliability of the instrument

Reviews

Write a Review

Financial Management Questions & Answers

  Foreign company acquisition

Acquisition by a foreign company and the effects of that decision and the results of foreign exchange in Euro and the exchange rate differences.

  Financial management for profit and non profit organizations

In this essay, we are going to discuss the issues of financial management in a non-profit organisation.

  Method for estimating a venture''s value

Evaluate venture's present value, cash and surplus cash and basic venture capital.

  Replacement analysis

This document show the Replacement Analysis of modling machine. Is replacement give profit to company or not?

  Business finance task - capital budgeting

Your company is considering using the payback period for capital-budgeting. Discuss the advantages and disadvantages of this technique.

  Analysis of the investment

In this project, you will focus on one of these: the additional cost resulting from the purchase of an apple press (a piece of equipment required to manufacture apple juice).

  Conduct a what-if analysis

Review the readings and media for this unit, including the Anthony's Orchard case study media. Familiarise yourself with the Anthony's Orchard company and its current situation.

  Determine operational expenditures

Organisations' behaviour is guided by financial data. In the short term, such data will help determine operational expenditures; in the long term, historical data may help generate forecasts aimed at determining strategic plans. In both instances.

  Personal financial management

How much will you have left over each half year if you adopt the latter course of action?

  Sources of finance for expansion into new foreign markets

A quoted company is considering several long-term sources of finance for expansion into new foreign markets.

  Long term financial planning

This assignment is designed for analyze Long term financial planning begins with the sales forecast and the key input in the long term fincial planning.

  Explain the role of fincial manager

This assignment explain the role of fincial manager, function of manger. And what are the motives of financial manager.

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