Module $2$ Venture Aviation case analysis need help solving Hangar NPV spreadsheet Loan amortization sheet $,$ and breakeven sheet shown below is all the relevant information for all $3$ sheets $.$

Ventura Aviation Start $12345678$ TV Key Assumptions Construction cost $($$$)1,150,000$ Loan $($$$)550,000$ Loan interest rate $7\mathrm{.}8\%$ Loan term $($yrs$.)8$ Hangar space $($sq$.$ft$.)22,000$ Rent $($$$/$sq$.$ft$.$ per month$)1\mathrm{.}10$ Rent inflator $2\mathrm{.}20\%$ Operating Costs $($$$/$yr$.)105,000$ Cost inflator $2\mathrm{.}10\%$ Tax rate $21\mathrm{.}0\%$ Discount rate $7\mathrm{.}5\%$ Depreciation$/$year $($$$)45,000$ Cash Flows Rent Income $$ minus: Operating Costs $$ minus: Interest $$ minus: Depreciation $=$ Taxable Income $$ minus: Taxes $=$ Net Income $$ minus: Principal $=$ Net Operating Cash Flow $$ minus: Cash Outlay at Start $$ plus: Depreciation $=$ Total Cash Flows $$ NPV $$ IRR $$ Note: Tax shields are the tax gains from expensing interest and depreciation.$$ The formula is interest or depreciation expense times the tax rate $$