Your company is undertaking a new project. A building was purchased 5 years ago for $1,000,000 depreciated straight line to $100,000 (the land value) over 30 years. It is now worth $600,000 (including $100,000 land).

The project requires improvements to the building of $200,000. The improvements are depreciated straight line to zero over the life of the project.

The project will generate revenues of $325,000, $350,000, $375,000 and $400,000 for years 1-4, respectively. Annual cash operating expenses are $180,000, $200,000, $220,000 and $240,000, respectively.

The project will last 4 years, at which time the building will be sold for $800,000.

a)What is the total depreciation per year?

b)Show projected annual income statements.

c)What is the initial cost (CF0)?

d)What are annual operating Cash Flows?

e)What is the ending Cash Flow from the sales of the assets?

f)What is the total annual Cash Flows?

g)What is NPV? Show work

h)What is Profitability Index? Show work.

I)What is payback in whole years?

J)What is Average Accounting Return?

K)Show the format for IRR. Need to equation, not answer.

It is one question in several parts. Show work on excel Thanks!

show work in excel!