Share
Explore BrainMass

Analyze financial statements, prepare cash flow analysis

It is expected to produce US$3.5 million in revenue annually the first year and grow 5% per year thereafter.

The project will increase operating expenses by US$1.75 million the first year and grow at 3% annually per year thereafter.

The project cost US$6 million in capital, and the capital will be depreciated on a straight-line basis for 5 years.
The US$6 million will all be spent in the year prior to the first year in which the company generates revenue.

The company will evaluate the project over 5 years (not including year 0).

The company has a 40% tax rate.

For this project you will use a 12% cost of capital and a 13% reinvestment rate.

Given this information, find the NPV, MIRR, and which year the present value cash flows become positive. I need this in an excel spreadsheet as well as 5 slides w/ notes

Solution Preview

Analyze financial statements, prepare cash flow analysis and pro forma statements.

It is expected to produce US$3.5 million in revenue annually the first year and grow 5% per year thereafter.

The project will increase operating expenses by US$1.75 million the first year and grow at 3% annually per year thereafter.

The project ...

Solution Summary

This explains the steps to Analyze financial statements, prepare cash flow analysis and pro forma statements

$2.19