finance long lived asset

Given

buy an asset for $ 1 million

Dep 5 years

rev $ 5 Million

COGS $ 3 milion

Tax Rate 25%

I need Excel sheet for this homework,

_ extand the example we did in class to cover the entire 5 years ( life of asset).

_ show balance sheet

1- cash

2- assets

for 5 years

_show cash statement

1- operating

2- investment

for 5 years

– all numbers must be computed (not entered) except for basic inputs.