J14 1 x fx (price taxes) A B D E F G 1 Bought a building 3 year ago for 300,000$. Depreciation to 30,000$ (land) over 30 years. 2 Now worth 350,000$. Expect to sell at end for 400,000$ 3 Project is 3 years. Taxes=20% Rate= 10% 4 5 Revenue 500,000 600,000 700,000 6 Cost=40% of revenue 7 8. Using excel prepare the spreadsheet and upload. 9 1. What is the total depreciation per year? 10 2. Show projected annual statement 11 3. What is the initial cost? 12 4. What are the annual operating cash flows? 13 5. What is the ending cahs flow from the sales of the assets? 14 6. What is the total annual cash flow? 15 7. What is NVP? Show work 16 8.What is profitability index? Show work 17 9. What is payback in whole years? 18 10. What is average accounting return? 19 11. Show how ( algebreic format), IRR would be solved ( don't solve) 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 Sheet1 + Enter 15,699 JUN 10