Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

need discounted cash flows, cumulative cash flow, cumulative discounted cash flow formulas for i through r all cells in red are incorrect. so i dont

need discounted cash flows, cumulative cash flow, cumulative discounted cash flow formulas for i through r
image text in transcribed
all cells in red are incorrect. so i dont know what im doing wrong image text in transcribed
image text in transcribed
image text in transcribed
image text in transcribed
image text in transcribed
image text in transcribed
never mind, they cant get any clearer
.0.651 JUMIERS accordi 1 land total p ngs in the 2704. 0 2 .2.10 er Tares to begative Carving Batep.Com Met. Proceeds of Disposals Change in Ne Working Capital R opponunt costs Wing Cash Flow 11.000.000 990.000 . 000000 5.000 375.000 2,260,400 .000 2,165,740 .000 M 2.173,045 2 60001 31,140 146 2 2 375.00 2,445 858 15000 2,574515 DOL 2.700.00 2. 0 0 3.600 Discounted Cash Flows curve Cash Flow Cumuluscounted cash flow RR Panback Discounted Payback Potability index RS Revenue on new Proud Une COGS Sales General & Admin Costs Deprecation Com hele below) EBIT Tas Not Income Al Back Depreciation om schedule) Lear n Costs from sche Operating cash flows 6620.000 A 190 LLLLLLL 20. 06 0131.992.10.799.32149129 2 .80 401 4 .500 100 101457 5 082 3 95,675 M5 .03.7845 977 977 .09.085 E 211204.10 502.6320001 92.647414754090219 11.961.23 2002 2040. 2 307740 ALUMBALL 32240100 10. 0 72350520.94314022421911,5102537401284.018 4 5. 33. 709.684 (192027) 114. 0081 4 20555 10.23 722 484 8354 3 .4051010.13 1230PP .COM 040912018173 2 3380242072554 101. 3206 ORRM204012120774 9 29 122 8 010 248,310254209 11 299 110 2 5 2,260,860 12.165.740 2.1/8 015 2014 2.445.ES 7.972368 Enter a venues and costs as posive number counterfows versus out the totals and totals. Ai p o are to be negative 110.00.000 nementales Captanding Baru Coats A Tax Proceso sposals Change in Networking Capital Relevantn ost Inmental Cash Flow cash Flows Cumulative Cash Flow Cumulative Diacounted cash flow Newlue Discounted Payback abihinde P Schedule R o sion Costs 1350200 1.436,602 1 528.568 7.18 920574 .990 1 03300 1120.894 182.683126.990 5918456231a902571207758.33 30328040820401,01034122 ONLINE 204 205 281,118 799,110 1182533 621350,93 41 machine 15 4000212401209.440 .064 164 33274373274 0.012 Discounted Payback Profily Index Schedule Revenue Erosion Costs Lost Revenue Related coas Gross 1500 70.020 2474 BOLO 120 924 1 02003 7 12.07 . 23 MOOTH 0 508. 123.338621 20 209 BE 4914 108,125 383351 14 02212 9119921972.16 522.930 5 58998 115.048 1 22.408 407885 101, 101691 3 60293 299 110 Schedus Depron machine 10 MACRS L) machine 2 MACRS Lite) 354 59223 22 1961.22 3.4009 102101022 2060822 .040 5221 011 1.050. 766106 73274 1111010 146.010 2000 1200 1 9 NACALCIO VIP ADA Weighted 72 .000.000 NEEDER ost of Equity cost of capt Weight Costel Costa Balance We 15.800.000 12.100.000 2000 Home Insert Or Page Layout Formulas Duits Review Yew D e al Pows Capleting ACC Compite (1 me you wanted Cowy - 2 27 Complete WACC and Capital Budgeting Exercise Complete al green shaded c ake f o schedules to come below asaras low / ALL ALL ME A pu Tent Page Form Date Review View O Capbudgeting WACC Comic Bece Tea you want to do ptHelp Fowel Home XCM C AndVA > > XA TOD32 Type here to search Date Review View Developer Hele Power Pivet Tell me what you want to do Amber Champou Merge Center . Cool and & Select- Revenue on new Product Sales General Admin Costs Depreciation om schedule below C OSE WWW 5200091943.100 .1472222 2 251010. 1109210790,5711401959 772 204,000 1987 TOTS50237567515459773 22.5ool 521.17051491732500009900414754 1189 1.205.0R22040522921450 7501520 419 420 41628740 2764.0109 .445 433004/02684 92114 20. 5022 METALL 15342062. 330 5 54 20022040, POZ E F 20.315 LL . 1923 3351 407 7.280.807 -162740 11, 7 244825745152 .7041602912168 3.219.563 Enter will revenues and costs as posive numbers, en account for Wow was the s tanda r Tares to be 11.000.000 Net Income Add ac Depreciation from Less Erion Corom sche) Operating Flows D C After Proceeds of Change in Networking Capital Relevant Oportunitats Curve Cash Flow Cuma buscounted Cashow 1 31 939374 2145 11.01. 755301 434122 02.09 1213 200 356223 49547 Discounted Payback Profitability Index Schedule Revenue Erosion Costs Last Revenue Related COGS Cross prot Nation Costs NO: 200 1200 , 192663 683 0047418419 435497640 1/239.110 218.253 893 70 191 502091436622 7 913092 491078 W.522930 25 15.045 151 338.621 972160 5863 12400 433.990 Schedule Depot chine 15 Mar MACHS machine 2 MAC 360293 407. Lite 212400309 199.440 TOT 4 920 102020 224324 3.206,0122 .040.522 1007 106 1.158.838 7 56106 274 3 73714 195.00 185010 WACC. COM 0 .000 wwghted SYM393 12.350 000 A KC) Costel Costa Weighted 7.945 .0.651 JUMIERS accordi 1 land total p ngs in the 2704. 0 2 .2.10 er Tares to begative Carving Batep.Com Met. Proceeds of Disposals Change in Ne Working Capital R opponunt costs Wing Cash Flow 11.000.000 990.000 . 000000 5.000 375.000 2,260,400 .000 2,165,740 .000 M 2.173,045 2 60001 31,140 146 2 2 375.00 2,445 858 15000 2,574515 DOL 2.700.00 2. 0 0 3.600 Discounted Cash Flows curve Cash Flow Cumuluscounted cash flow RR Panback Discounted Payback Potability index RS Revenue on new Proud Une COGS Sales General & Admin Costs Deprecation Com hele below) EBIT Tas Not Income Al Back Depreciation om schedule) Lear n Costs from sche Operating cash flows 6620.000 A 190 LLLLLLL 20. 06 0131.992.10.799.32149129 2 .80 401 4 .500 100 101457 5 082 3 95,675 M5 .03.7845 977 977 .09.085 E 211204.10 502.6320001 92.647414754090219 11.961.23 2002 2040. 2 307740 ALUMBALL 32240100 10. 0 72350520.94314022421911,5102537401284.018 4 5. 33. 709.684 (192027) 114. 0081 4 20555 10.23 722 484 8354 3 .4051010.13 1230PP .COM 040912018173 2 3380242072554 101. 3206 ORRM204012120774 9 29 122 8 010 248,310254209 11 299 110 2 5 2,260,860 12.165.740 2.1/8 015 2014 2.445.ES 7.972368 Enter a venues and costs as posive number counterfows versus out the totals and totals. Ai p o are to be negative 110.00.000 nementales Captanding Baru Coats A Tax Proceso sposals Change in Networking Capital Relevantn ost Inmental Cash Flow cash Flows Cumulative Cash Flow Cumulative Diacounted cash flow Newlue Discounted Payback abihinde P Schedule R o sion Costs 1350200 1.436,602 1 528.568 7.18 920574 .990 1 03300 1120.894 182.683126.990 5918456231a902571207758.33 30328040820401,01034122 ONLINE 204 205 281,118 799,110 1182533 621350,93 41 machine 15 4000212401209.440 .064 164 33274373274 0.012 Discounted Payback Profily Index Schedule Revenue Erosion Costs Lost Revenue Related coas Gross 1500 70.020 2474 BOLO 120 924 1 02003 7 12.07 . 23 MOOTH 0 508. 123.338621 20 209 BE 4914 108,125 383351 14 02212 9119921972.16 522.930 5 58998 115.048 1 22.408 407885 101, 101691 3 60293 299 110 Schedus Depron machine 10 MACRS L) machine 2 MACRS Lite) 354 59223 22 1961.22 3.4009 102101022 2060822 .040 5221 011 1.050. 766106 73274 1111010 146.010 2000 1200 1 9 NACALCIO VIP ADA Weighted 72 .000.000 NEEDER ost of Equity cost of capt Weight Costel Costa Balance We 15.800.000 12.100.000 2000 Home Insert Or Page Layout Formulas Duits Review Yew D e al Pows Capleting ACC Compite (1 me you wanted Cowy - 2 27 Complete WACC and Capital Budgeting Exercise Complete al green shaded c ake f o schedules to come below asaras low / ALL ALL ME A pu Tent Page Form Date Review View O Capbudgeting WACC Comic Bece Tea you want to do ptHelp Fowel Home XCM C AndVA > > XA TOD32 Type here to search Date Review View Developer Hele Power Pivet Tell me what you want to do Amber Champou Merge Center . Cool and & Select- Revenue on new Product Sales General Admin Costs Depreciation om schedule below C OSE WWW 5200091943.100 .1472222 2 251010. 1109210790,5711401959 772 204,000 1987 TOTS50237567515459773 22.5ool 521.17051491732500009900414754 1189 1.205.0R22040522921450 7501520 419 420 41628740 2764.0109 .445 433004/02684 92114 20. 5022 METALL 15342062. 330 5 54 20022040, POZ E F 20.315 LL . 1923 3351 407 7.280.807 -162740 11, 7 244825745152 .7041602912168 3.219.563 Enter will revenues and costs as posive numbers, en account for Wow was the s tanda r Tares to be 11.000.000 Net Income Add ac Depreciation from Less Erion Corom sche) Operating Flows D C After Proceeds of Change in Networking Capital Relevant Oportunitats Curve Cash Flow Cuma buscounted Cashow 1 31 939374 2145 11.01. 755301 434122 02.09 1213 200 356223 49547 Discounted Payback Profitability Index Schedule Revenue Erosion Costs Last Revenue Related COGS Cross prot Nation Costs NO: 200 1200 , 192663 683 0047418419 435497640 1/239.110 218.253 893 70 191 502091436622 7 913092 491078 W.522930 25 15.045 151 338.621 972160 5863 12400 433.990 Schedule Depot chine 15 Mar MACHS machine 2 MAC 360293 407. Lite 212400309 199.440 TOT 4 920 102020 224324 3.206,0122 .040.522 1007 106 1.158.838 7 56106 274 3 73714 195.00 185010 WACC. COM 0 .000 wwghted SYM393 12.350 000 A KC) Costel Costa Weighted 7.945

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

More Books

Students also viewed these Accounting questions