Generate a cash flow forecast

Reference no: EM131200130

Financial Forecasting Assignment-

The historical financial statements of HWO Incorporated are on the accompanying EXCEL file. Enter your assigned number in cell l1 (eye one). This is your individual data set. Print the page as the first page of your homework package.

On the "pro formae" tab you will find a template with no coding to use. You will find some compulsory assumptions. Your first job is to do a three-year pro forma analysis -fill in the template. Here are some more assumptions.

1. Cost of sales and selling expense are variable. General expense is a fixed cash operating cost.

2. Income tax rate has risen to a flat 0.41

3. Receivables, inventory, accounts payable and accruals are the only spontaneous working capital items.

4. 2015 capital investment for replacement purposes was $111 [million]

5. Capital investment for expansion will be in proportion to sales growth. Use the method [modified as needed] that I showed you.

6. Depreciation is 1/14 of previous year's gross fixed assets

Just like we did in class, note all assumptions [including yours] in each row.

Write a one or two-sentence comment on the meaning of your "plug" figures. Print this pro forma to fit one page for page 2 of your package.

Your second job is to use the same assumptions to generate a cash flow forecast [EBITDA method], using the template under the EBITDA tab. Print this as the third page in your submission package.

In the grading, error has different weights, based on the severity.

Attachment:- Assignment.rar

Reference no: EM131200130

Questions Cloud

How much will price of maracas change with per unit tax : How much will the price of maracas change with a per-unit tax of $2? - Who bears the larger burden of the tax, consumers or producers?

Discuss consequences business might face for misclassifying : Explain the pros and cons of hiring someone as an employee versus an independent contractor. Discuss what, if any, legal liabilities and responsibilities a business has for its employees as compared to independent contractors.

A strategic use of the value chain model : A "Best-Cost" strategy is most like which other generic business strategies? A strategic use of the value chain model is:

Draw a suitable schematic diagram for an isolation amplifier : Draw a suitable schematic diagram for an isolation amplifier, and explain the operation of this device.

Generate a cash flow forecast : Write a one or two-sentence comment on the meaning of your "plug" figures. Print this pro forma to fit one page for page 2 of your package. Your second job is to use the same assumptions to generate a cash flow forecast [EBITDA method], using the ..

Which type of travel will bear the larger burden of the tax : Airlines can price discriminate between these groups; that is, they can charge different prices to the different types of fliers in the market.- Which type of travel will bear the larger burden of the tax? Explain.

Write a six paragraph essay based on the mi theory : Write a 6 paragraph essay based on the MI Theory. Intro paragraph as well as the connclusion paragraph are included with the 6. All the instructions are below.

Describe two devices where amplitude modulation present : Also, describe two devices where amplitude modulation might be naturally present. Could the fact that amplitude modulation is present be exploited to our advantage in these two natural situations as well? Explain

Defender strategy typically involves which types of behavior : Characteristics of an Reactor firm include (check all that apply - you may have to check several boxes to receive full credit): A defender strategy typically involves which types of behavior (check all that apply - you may need to check more than one..

User Account

All Pages