I need help with the below Cash Flow Estimation Exercise:

Information to Solve Case:

Assume Bloomington Indiana Mellencamp Health System, a not-for profit hospital, is evaluating a new MRI.

Cost Purchase price: $500,000 Shipping and Install $80,000

Expected life 5 years

Salvage Value $250,000

Utilization 6000 scans per year

Net Revenue $150 per scan

Variable Cost $75 per scan

Fixed cost $150,000

Corporate cost of capital 12%

Calculate the operating cash flow for years 1- 4:

Year 1 Year 2 Year 3 Year 4

Revenue: _____ ______ _____ ______

Total Variable Cost: _____ ______ _____ ______

Fixed Costs: _____ ______ _____ ______

Depreciation: _____ ______ _____ ______

BT operating income: _____ ______ _____ ______

Taxes: _____ ______ _____ ______

AT operating income: _____ ______ _____ ______

Depreciation: _____ ______ _____ ______

Net op. CF: _____ ______ _____ ______