"Frank Smith Plumbing's Financial Statement" spreadsheet

I need these problems solved and show work on the tab "show work". Also include brief recommendations on the spreadsheet.

Frank Smith Plumbi Cost of Capital (borrowing) Cost of Truck Cost of additional equiment attached to truck Tax rate Annual Before Tax & Depreciation Truck Projected Earnings Data Needed for analysis: Project 12.00% $200,000 $15,000 35% Depreciation Percentage Rate (MACRS)* * The proposed truck has an estimated economic life of seven years but will be treated as a five-year MACRS property Calculate the following -- light yellow highlighted cel Year-0 Annual Before Tax & Depreciation Truck Projected Earnings Depreciation Expense Annual Before Tax Truck Projected Earnings Tax Annual Projected Truck Earnings Depreciation to add back Projected Truck Net Cash Flow Decision Criteria: Pay Back Period Discounted Pay Back Period (DPB)** Net Present Value Internal Rate of Return Profitability Index Discounted Cash Flow Needed for DPB Calc. Recommendations: rank Smith Plumbing Data Needed for analysis: Year-1 Year-2 Year-3 Year-4 Year-5 Year-6 Year-7 $70,000 $65,000 $60,000 $55,000 $50,000 $40,000 20.0% 32.0% 19.2% 11.5% as a five-year MACRS property for depreciation purposes. 11.5% 5.8% 0.0% Year-5 Year-6 Year-7 $70,000 g -- light yellow highlighted cells need to be completed Year-1 Decision Criteria: Years Years Recommendations: Year-2 Year-3 Year-4 Year-8 $30,000 0.0% Year-8