I am working on this case study and I need to find values for an inflation impact table (See below). I am providing you with an image of the table that is completed already. I would like to know how these values were calculated in this table. Specifically, I need to know what formulasumbers are needed to find the values needed for this table?
Here is the chart with the values already filled in:
Impact of Uncertain, Future Inflation on NPV: $1,200,857 0% 1% 2% 0% 872,076 807,289 Level of Cost 741,258 Inflation 3% 673,964 1% 605,389 5% 535,514 6% 464,322 1% 1,044,380 979,594 913,563 846,269 777,693 707,819 636,626 Level of Net Patient Revenue Inflation 3% 1,398,968 1,334,182 4% 1,501,349 1,516,563 1,450,532 1,268,151 1,200,85/ 1,383,238 1,311,662 1,132,282 1,062,407 1,244,788 1,173,595 991,214 2% 1,219,995 1,155,209 1,089,177 1,021,883 953,308 883,434 812,241 5% 1,767,186 1,702,400 1,636,368 1,569,0/4 1,500,199 1,430,625 1,359,432 6% 1,956,528 1,891,742 1,825,711 1,758,41/ 1,689,812 1,619,967 1,548,774 CASE 70 CORAL DAY HOSPITAL: Tradial Project Gal 12/4/2017 Copyright 2013 Foundation of the Arrancan College of Healthcare Executives. Not for . Model, Instructor Version Technicales coerplula capital beadqating anapka, inducing cat low apa, and prostaty measures. Note that the model extends to Colum The model consists of a criolete case oase anayas-no charges need to be made to the coding MOXIF-GENERATESTATA or Howwe, valaminte DPLE DALAI LA screesheet have been replaced by zeros. Students must select appropriate hout values and enter at them in the cell wielreded After the cone, anyame can wil become and T KEY OUTFLToninas the most p from the MOOEL GENERATED DATA The Instructor version of the model contains ar inflado table. sensitate arabs, and soman artes, which ww ndesheer van. A graphitetty or the second chcet NEVI DATA KEY OUTPUT din stra $IMICO $1,754 KPV IFR Land opportunity ecst (and salvage value) $200.000 12.95 ment 510.000.000 WIBR 11.9% $5,000,000 Farback 41 Bunartachys LU Procedures per day ANIM 20.00 Aramalgalan $1.000 Laber $:18.070 LIN 3540000 norcrcrial over 330.000 Supply $7:0 mation annet patient revenus wton wool 3.3% 13% MXM 40.0% Revenues let them incadent suceder $1.000.000 Rachacryla Cost of p $500,000 9.0% MODEL-GENERATED DATA Dypuraku Sm Year Sk he Cay 1 2 3 4 5 and panel . 2 Net patient revenue includ rg Inpatient loss! 5400005 $4.120.000 54,241,000 54.370 85 LL 918003 245,540 972,008 1028 123 Cost savings or rpateris (000,000) (10.0001 103.400 (346 304) $4.502.035 1.283.217 1562.7541 52 M 1,120.000 2008 53000 3,0 KIN Supplies 1000000 130.000 1.000.000 1.032 727 380015 3700 3518 24:15 20,00 Increment Depreciat Income here 2.000.000 9,200,000 1.000.000 1200 000 1.100.000 5458003 (28.1201 STAR.COM 51327447 $1,708,270 128 405 2518481 (8377 472103 910 970 $81,708 $916 475 $1,272 Froject et rome Dese $257005 2020.005 (53774721 2,200,000 1,900,000 1220000 1,100,000 100.000 Plus: Netlandsakageu Ma: Nethe 3,700,0 Now 1514,300.000 522895 $2,822,478 32.34 $20K $55, 1510,200.0001 1578:2003) ($5.78.372) 52.731,563) 15614600) $4,800.982 Camative net cash now (Fursadzach zakudal Fulya Brava M (NPV) 5120 menal race of retur (IRR) 12.9% 1135 Moded B Payback 4.1 Impu Lewr, Futon NPV. $1.200.857 0% 15 Level II 2% 35 TO 44 4% 08 121985 3,241888 IMUSN 1,78/188 1.155.200 1,394,152 1,515,502 1.700 400 8/2175 1,044/IN 0% 1,RM,278 1,501,742 15 827,281 579.904 of Col 741 255 101 127 1,71,1M. 145, 163836 1,125,711 $13,383 HANDA 848,280 AM3 hatan 873.904 1.021.883 1,200,857 1,583,298 1,559 074 1,758,417 37623 777.683 823300 1.132.212 1.314,067 1.500 499 1209 347 67530 5:55:4 707,819 825494 1,062407 1,214,788 1420 825 1,619.087 404322 430.020 812241 0214 1,173,500 1350432 1,549.774 Staty thote This table does NOT automatical y reca eclate when input values are changed. AR EN E N Procedures (1 757.785) per Frocedure Sokage value -32% 2,4974141 9815912 910.095 -27% 1,264.651 (771,654) 214 811 -12% 131820 1025 827 255 1.200,837 120.837 1.200.857 218/IM 7,4314413 135 BIS 2055 3173,205 9,800.371 150818 415 474 4.128.130 1.715 795 SA. thote This section does NOT autonztcally recalou ate win wakes in the NFUT DATA sede are changed ore pe within the cente changed and teng will automady be related. Ang Reven Blup Equ per Frocesire Sage Vale Pho Mamlur u" Frocedures 10 -0 CHA Waral Most Likely Seal NEV (5,562,87 1803 1.005 $4,500,000 3.000.000 135 20 250% 50.0% 25.05 105.764 100.0% www 1,207,567 135,222 25 1203 8.000.000 Expected MPV Standard Devia $1,048,782 $4.410.931 4.2 Como Ver 4 5 H ******* 5% MAINS D Factor Expense $1.000 4.35 0.32 3,200.000 0.12 3,8cm 0.12 1,200,000 0.11 1.100.00 0.08 800,000 Pr th $200.000) (10,000,000 Endal Yo Ebok value SOCI 4820000 2800000 1.700.000 60.000 END Impact of Uncertain, Future Inflation on NPV: $1,200,857 0% 1% 2% 0% 872,076 807,289 Level of Cost 741,258 Inflation 3% 673,964 1% 605,389 5% 535,514 6% 464,322 1% 1,044,380 979,594 913,563 846,269 777,693 707,819 636,626 Level of Net Patient Revenue Inflation 3% 1,398,968 1,334,182 4% 1,501,349 1,516,563 1,450,532 1,268,151 1,200,85/ 1,383,238 1,311,662 1,132,282 1,062,407 1,244,788 1,173,595 991,214 2% 1,219,995 1,155,209 1,089,177 1,021,883 953,308 883,434 812,241 5% 1,767,186 1,702,400 1,636,368 1,569,0/4 1,500,199 1,430,625 1,359,432 6% 1,956,528 1,891,742 1,825,711 1,758,41/ 1,689,812 1,619,967 1,548,774 CASE 70 CORAL DAY HOSPITAL: Tradial Project Gal 12/4/2017 Copyright 2013 Foundation of the Arrancan College of Healthcare Executives. Not for . Model, Instructor Version Technicales coerplula capital beadqating anapka, inducing cat low apa, and prostaty measures. Note that the model extends to Colum The model consists of a criolete case oase anayas-no charges need to be made to the coding MOXIF-GENERATESTATA or Howwe, valaminte DPLE DALAI LA screesheet have been replaced by zeros. Students must select appropriate hout values and enter at them in the cell wielreded After the cone, anyame can wil become and T KEY OUTFLToninas the most p from the MOOEL GENERATED DATA The Instructor version of the model contains ar inflado table. sensitate arabs, and soman artes, which ww ndesheer van. A graphitetty or the second chcet NEVI DATA KEY OUTPUT din stra $IMICO $1,754 KPV IFR Land opportunity ecst (and salvage value) $200.000 12.95 ment 510.000.000 WIBR 11.9% $5,000,000 Farback 41 Bunartachys LU Procedures per day ANIM 20.00 Aramalgalan $1.000 Laber $:18.070 LIN 3540000 norcrcrial over 330.000 Supply $7:0 mation annet patient revenus wton wool 3.3% 13% MXM 40.0% Revenues let them incadent suceder $1.000.000 Rachacryla Cost of p $500,000 9.0% MODEL-GENERATED DATA Dypuraku Sm Year Sk he Cay 1 2 3 4 5 and panel . 2 Net patient revenue includ rg Inpatient loss! 5400005 $4.120.000 54,241,000 54.370 85 LL 918003 245,540 972,008 1028 123 Cost savings or rpateris (000,000) (10.0001 103.400 (346 304) $4.502.035 1.283.217 1562.7541 52 M 1,120.000 2008 53000 3,0 KIN Supplies 1000000 130.000 1.000.000 1.032 727 380015 3700 3518 24:15 20,00 Increment Depreciat Income here 2.000.000 9,200,000 1.000.000 1200 000 1.100.000 5458003 (28.1201 STAR.COM 51327447 $1,708,270 128 405 2518481 (8377 472103 910 970 $81,708 $916 475 $1,272 Froject et rome Dese $257005 2020.005 (53774721 2,200,000 1,900,000 1220000 1,100,000 100.000 Plus: Netlandsakageu Ma: Nethe 3,700,0 Now 1514,300.000 522895 $2,822,478 32.34 $20K $55, 1510,200.0001 1578:2003) ($5.78.372) 52.731,563) 15614600) $4,800.982 Camative net cash now (Fursadzach zakudal Fulya Brava M (NPV) 5120 menal race of retur (IRR) 12.9% 1135 Moded B Payback 4.1 Impu Lewr, Futon NPV. $1.200.857 0% 15 Level II 2% 35 TO 44 4% 08 121985 3,241888 IMUSN 1,78/188 1.155.200 1,394,152 1,515,502 1.700 400 8/2175 1,044/IN 0% 1,RM,278 1,501,742 15 827,281 579.904 of Col 741 255 101 127 1,71,1M. 145, 163836 1,125,711 $13,383 HANDA 848,280 AM3 hatan 873.904 1.021.883 1,200,857 1,583,298 1,559 074 1,758,417 37623 777.683 823300 1.132.212 1.314,067 1.500 499 1209 347 67530 5:55:4 707,819 825494 1,062407 1,214,788 1420 825 1,619.087 404322 430.020 812241 0214 1,173,500 1350432 1,549.774 Staty thote This table does NOT automatical y reca eclate when input values are changed. AR EN E N Procedures (1 757.785) per Frocedure Sokage value -32% 2,4974141 9815912 910.095 -27% 1,264.651 (771,654) 214 811 -12% 131820 1025 827 255 1.200,837 120.837 1.200.857 218/IM 7,4314413 135 BIS 2055 3173,205 9,800.371 150818 415 474 4.128.130 1.715 795 SA. thote This section does NOT autonztcally recalou ate win wakes in the NFUT DATA sede are changed ore pe within the cente changed and teng will automady be related. Ang Reven Blup Equ per Frocesire Sage Vale Pho Mamlur u" Frocedures 10 -0 CHA Waral Most Likely Seal NEV (5,562,87 1803 1.005 $4,500,000 3.000.000 135 20 250% 50.0% 25.05 105.764 100.0% www 1,207,567 135,222 25 1203 8.000.000 Expected MPV Standard Devia $1,048,782 $4.410.931 4.2 Como Ver 4 5 H ******* 5% MAINS D Factor Expense $1.000 4.35 0.32 3,200.000 0.12 3,8cm 0.12 1,200,000 0.11 1.100.00 0.08 800,000 Pr th $200.000) (10,000,000 Endal Yo Ebok value SOCI 4820000 2800000 1.700.000 60.000 END
