Please see the Excel file

1 answer below »

Answered Same Day Sep 03, 2021

Solution

Shakeel answered on Sep 04 2021

146 Votes

Sheet1
    Northeast Hospital is analyzing a potential project for a new outpatient cente
    Please use the following facts to create a 5-year projection of cash flow for the proposed center. Please create your full income statement first to include all cash and non-cash expenses
    Calculate the projects NPV, IRR, MIRR, Payback Period (not discounted). Using these calculations, do you recommend that they should proceed with this project? Explain your answe
                                                    Cash flow statement
                            Year 1    Year 2    Year 3    Year 4    Year 5
    Total projected Visits                    52500    52500    57750    60638    62457    64330            Year 0    Year 1    Year 2    Year 3    Year 4    Year 5
    Average Revenue per visit                    $ 75.00    $ 76.50    $ 78.03    $ 79.59    $ 81.18    $ 85.24        Initial Investment    $ (4,500,000.00)
    Average Variable Cost per Visit                    $ 50.00    $ 51.00    $52.02    $53.06    $54.12    $55.20        Revenue        $ 4,016,250.00    $ 4,506,232.50    $ 4,826,175.01    $ 5,070,379.46    $ 5,483,615.39
    Total Fixed Costs                    $ 500,000.00    $ 505,000.00    $ 510,050.00    $ 515,150.50    $ 520,302.01    $ 525,505.03        Less: Variable cost        $ 2,677,500.00    $ ...

SOLUTION.PDF

Please see the Excel file

Solution

Answer To This Question Is Available To Download

Related Questions & Answers

Submit New Assignment