Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

How would I create this in a spread sheet in excel? Please Show as much steps examples as possible. The firm just spent $300,000 for

How would I create this in a spread sheet in excel? Please Show as much steps examples as possible.

The firm just spent $300,000 for a marketing study to determine consumer demand (@ t=0).

Aero Motorcycles purchased the land the factory will be built on 5 years ago for $2,000,000 and owns it outright (that is, it does not have a mortgage). The land has a current market value of $2,518,987.

The project has an initial cost of $20,000,000 (excluding land, hint: the land is not subject to depreciation).

If the project is undertaken, at t = 0 the company will need to increase its inventories by $3,500,000, accounts receivable by $1,500,000, and its accounts payable by $2,000,000. This net operating working capital will be recovered at the end of the projects life (t = 10).

If the project is undertaken, the company will realize an additional $8,000,000 in sales over each of the next ten years. (i.e. sales in each year are $8,000,000)

The companys operating cost (not including depreciation) will equal 50% of sales.

The companys tax rate is 35 percent.

Use a 10-year straight-line depreciation schedule.

At t = 10, the project is expected to cease being economically viable and the factory (including land) will be sold for $4,500,000 (assume land has a book value equal to the original purchase price).

The projects WACC = 10 percent

Assume the firm is profitable and able to use any tax credits (i.e. negative taxes).

How would I create this in a spread sheet in excel? Please Show as much steps examples as possible.

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

Contemporary Financial Management

Authors: R. Charles Moyer, William J. Kretlow, James R. Mcguigan

8th Edition

0324065914, 9780324065916

More Books

Students also viewed these Finance questions

Question

Dividends reduce earnings before taxes. True or false? Explain.

Answered: 1 week ago

Question

Make arguments for the union and for the employer.

Answered: 1 week ago