How would I go about calculating the impact of uncertain future inflation on NPV of a proposed
Fantastic news! We've Found the answer you've been seeking!
Question:
How would I go about calculating the impact of uncertain future inflation on NPV of a proposed ambulatory surgery center based on given levels of net patient revenue inflation and levels of cost inflation? Here's what I am given and have already calculated:
The follow boxes must be filled with NVPs:
What implications do these results have?
Transcribed Image Text:
INPUT DATA Land initial cost Land opportunity cost (& salvage val Building/equipment cost Building/equipment salvage value Procedures per day Average net revenue Labor costs Utilities costs Incremental overhead Supply cost ($/procedure) Inflation rate on charges Inflation rate on costs Tax rate (Fed+State) Revenues lost from inpatient surger Reduction in in-patient surgery cost Cost of capital Number of beds Year Land Opportunity cost Building/equipment cost Net Revenues Less: Labor costs Cost savings on in-patients Utilities Supplies Incremental overhead Depreciation Income before taxes Taxes Cumulative net cash flow $150,000.00 $200,000.00 $10,000,000.00 $5,000,000.00 Net Present Value (NPV) 20 $1,000.00 $918,000.00 $50,000.00 $36,000.00 $200.00 3.0% Project net income Plus: Depreciation Plus: Net land salvage value Plus: Net building/equipment salvage value Net cash flow Internal Rate of Return (IRR) Payback (in years) MIRR $1,000,000.00 $500,000.00 3.0% 40.0% Profitability & Breakeven Measures 9.0% 250 0 -$200,000.00 -$10,000,000.00 Calculations of Net Cash Flows 2 Year 1 2 1 3 4 5 6 $1,200,856.83 12.93% 4.1 11.45% Depreciation Schedule MACRS Factor 0.2 0.32 0.19 0.12 0.11 0.06 3 $4,000,000.00 $4,120,000.00 $4,243,600.00 $918,000.00 $945,540.00 $973,906.20 -$500,000.00 -$515,000.00 -$530,450.00 $50,000.00 $51,500.00 $53,045.00 $37,080.00 $1,000,000.00 $1,030,000.00 $1,060,900.00 $36,000.00 $38,192.40 $2,000,000.00 $3,200,000.00 $1,900,000.00 $496,000.00 -$629,120.00 $748,006.40 $198,400.00 -$251,648.00 $299,202.56 $297,600.00 -$377,472.00 $448,803.84 $2,000,000.00 $3,200,000.00 $1,900,000.00 Depreciation Expense $2,000,000.00 $8,000,000.00 $3,200,000.00 $4,800,000.00 $1,900,000.00 $2,900,000.00 $1,200,000.00 $1,700,000.00 $1,100,000.00 $600,000.00 $600,000.00 $0.00 4 -$10,200,000.00 $2,297,600.00 $2,822,528.00 $2,348,803.84 $2,116,467.96 End of Year Book Value 5 $4,370,908.00 $4,502,035.24 $1,003,123.39 $1,033,217.09 -$546,363.50 -$562,754.41 $54,636.35 $56,275.44 $1,092,727.00 $1,125,508.81 $39,338.17 $40,518.32 $1,200,000.00 $1,100,000.00 $1,527,446.59 $1,709,269.99 $610,978.64 $683,708.00 $916,467.96 $1,025,561.99 $1,200,000.00 $1,100,000.00 $180,000.00 $3,240,000.00 $5,545,561.99 -$10,200,000.00 -$7,902,400.00 $5,079,872.00-$2,731,068.16 -$614,600.20 $4,930,961.79 INPUT DATA Land initial cost Land opportunity cost (& salvage val Building/equipment cost Building/equipment salvage value Procedures per day Average net revenue Labor costs Utilities costs Incremental overhead Supply cost ($/procedure) Inflation rate on charges Inflation rate on costs Tax rate (Fed+State) Revenues lost from inpatient surger Reduction in in-patient surgery cost Cost of capital Number of beds Year Land Opportunity cost Building/equipment cost Net Revenues Less: Labor costs Cost savings on in-patients Utilities Supplies Incremental overhead Depreciation Income before taxes Taxes Cumulative net cash flow $150,000.00 $200,000.00 $10,000,000.00 $5,000,000.00 Net Present Value (NPV) 20 $1,000.00 $918,000.00 $50,000.00 $36,000.00 $200.00 3.0% Project net income Plus: Depreciation Plus: Net land salvage value Plus: Net building/equipment salvage value Net cash flow Internal Rate of Return (IRR) Payback (in years) MIRR $1,000,000.00 $500,000.00 3.0% 40.0% Profitability & Breakeven Measures 9.0% 250 0 -$200,000.00 -$10,000,000.00 Calculations of Net Cash Flows 2 Year 1 2 1 3 4 5 6 $1,200,856.83 12.93% 4.1 11.45% Depreciation Schedule MACRS Factor 0.2 0.32 0.19 0.12 0.11 0.06 3 $4,000,000.00 $4,120,000.00 $4,243,600.00 $918,000.00 $945,540.00 $973,906.20 -$500,000.00 -$515,000.00 -$530,450.00 $50,000.00 $51,500.00 $53,045.00 $37,080.00 $1,000,000.00 $1,030,000.00 $1,060,900.00 $36,000.00 $38,192.40 $2,000,000.00 $3,200,000.00 $1,900,000.00 $496,000.00 -$629,120.00 $748,006.40 $198,400.00 -$251,648.00 $299,202.56 $297,600.00 -$377,472.00 $448,803.84 $2,000,000.00 $3,200,000.00 $1,900,000.00 Depreciation Expense $2,000,000.00 $8,000,000.00 $3,200,000.00 $4,800,000.00 $1,900,000.00 $2,900,000.00 $1,200,000.00 $1,700,000.00 $1,100,000.00 $600,000.00 $600,000.00 $0.00 4 -$10,200,000.00 $2,297,600.00 $2,822,528.00 $2,348,803.84 $2,116,467.96 End of Year Book Value 5 $4,370,908.00 $4,502,035.24 $1,003,123.39 $1,033,217.09 -$546,363.50 -$562,754.41 $54,636.35 $56,275.44 $1,092,727.00 $1,125,508.81 $39,338.17 $40,518.32 $1,200,000.00 $1,100,000.00 $1,527,446.59 $1,709,269.99 $610,978.64 $683,708.00 $916,467.96 $1,025,561.99 $1,200,000.00 $1,100,000.00 $180,000.00 $3,240,000.00 $5,545,561.99 -$10,200,000.00 -$7,902,400.00 $5,079,872.00-$2,731,068.16 -$614,600.20 $4,930,961.79
Expert Answer:
Answer rating: 100% (QA)
Here is an example calculation using the figures provided 1 Define inflation scenarios Net ... View the full answer
Related Book For
Posted Date:
Students also viewed these finance questions
-
The Crazy Eddie fraud may appear smaller and gentler than the massive billion-dollar frauds exposed in recent times, such as Bernie Madoffs Ponzi scheme, frauds in the subprime mortgage market, the...
-
Managing Scope Changes Case Study Scope changes on a project can occur regardless of how well the project is planned or executed. Scope changes can be the result of something that was omitted during...
-
The following additional information is available for the Dr. Ivan and Irene Incisor family from Chapters 1-5. Ivan's grandfather died and left a portfolio of municipal bonds. In 2012, they pay Ivan...
-
Using a resource-based view, explain why some firms improve their economic performance by adopting a CSR strategy, whereas others achieve no results or damaging results.
-
What standard for limiting emissions into the air does Cotton Designs pollution-control equipment have to meet? In the late 1980s, residents of Lake Caliopa, Minnesota, began noticing an unusually...
-
The stock of Sedly Inc. is expected to pay the following dividends. Year 1 2 3 4 Dividend $2.30 $3.50 $1.75 $2.20 At the end of the fourth year its value is expected to be $37.70. What should...
-
An original loan of \($2,000\) was made at 6% simple interest per year for 4 yr. At the end of this time, no interest had been paid and the loan was extended for 6 yr more at a new effective compound...
-
On January 1, 2016, Technicians Credit Union (TCU) issued 7%, 20-year bonds payable with face value of $100,000. The bonds pay interest on June 30 and December 31. The issue price of the bonds is...
-
The solid shaft of radius r = 0.5 inches and shear modulus G = 10,000ksi is subjected to the torques shown, and T = 10,000lb - in. At the surface of the shaft, the angle between the "line before...
-
Reconstruct the following syllogistic forms and use the five rules for syllogisms to determine if they are valid from the Boolean standpoint, conditionally valid from the Aristotelian standpoint, or...
-
Corporation issues 100 shares of Preferred $2 stock, $100 par. What does the $2 represent? Premium Amount Total Dividends Dividend Rights per share Par Value
-
A writer compared letters and social media posts: What is special about a letter is the time that is taken in creating a letter that someone went to the trouble of finding a piece of paper, sitting...
-
J.P. Morgan Chase, the largest U.S. bank based on assets, stunned the usually conservative financial sector when it parted with longstanding tradition and started allowing business-casual attire on...
-
Blog writer Brian Drummond needs examples and information for a blog he plans to publish on the Online Voices platform. He writes to Nadya DeAlba, office manager at a high-tech firm, requesting...
-
As a member of the planning committee for an upcoming conference, you have been asked to draft a message requesting information about whether the venue is accessible for all participants. Your Task. ...
-
If there are any questions that you have about computer safety, please call us. Your Task. Revise the above sentence to avoid unnecessary there is/are and it is/was fillers.
-
Tsina Corporation, a resident carrier has the following data for the current year: Gross income of P1,000,000 and expenses of P300,000 from the Philippines Gross income of P600,000 and expenses of...
-
Consider the circuit of Fig. 7.97. Find v0 (t) if i(0) = 2 A and v(t) = 0. 1 3 ett)
-
Why would a union choose to engage in a work-to-rule campaign or a rotating strike rather than a fullscale strike?
-
Explain how interest arbitration differs from grievance arbitration.
-
Why is the CLC called the union of unions?
-
What can we learn from studying hunter-gatherer societies that might help us understand and interpret life in industrial societies today?
-
What are the benefits and limitations of conducting cross-cultural research?
-
What types of economic exchange would you expect to find in hunter-gatherer societies? Are the individuals in foraging societies more altruistic, magnanimous, and generous, or are they no more nobler...
Study smarter with the SolutionInn App