90.2K

Verified Solution

Link Copied!

having trouble with the excell formulas. please help. please show the excell formulas

the problem is requesting an excell format... I am not familiar with the key strokes or formula formation.

the yellow highlighted areas require an excell formula. please help to show the formula

The responses for the highlighted area require excel formulas based on the data given.

How do you formulate the excel formulas

Excel DATA REVIEW VIEW PROTECTED VIEW Be careful-files from the Internet can contain viruses. Unless you need to edit, it's safer to stay in Pratected View Enable Ed A1 fix Solution A 87 Project A B C D E F G H J K 88 Time period Cash flow Cumulative cash flow 0 89 90 3 4 (375) (300) (200) (100) 600 $600 $926 ($200) Intermediate calculation for payback 91 Payback using intermediate calculations) 93 94 Project B 92 95 Time period Cash flow Cumulative cash flow Intermediate calculation for payback Payback using intermediate calculations Payback using PERCENTRANK 0 2 5 6 7 96 97 98 99 100 101 102 a. 103 104 WACC Ok because cash flows follow normal pattern. At a cost of capital of 12 %, what is the discounted payback period for these two projects? 12% 105 106 Project A 107 Time period Cash flow Disc. cash flow Disc. cum, cash flow Intermediate calculation for payback Payback using intermediate calculations 1 2 3 108 109 110 111 112 113 114 Project B 115 116 117 118 119 6 4 5 3 Time period Cash flow 0 1 Disc. cash flow Disc. cum. cash flow Intermediate calculation for payback Payback using intermediate calculations 121 Discounted Payback using PERCENTRANK 120 Ok because cash flows follow normal pattern. 122 123 h. 124 What is the profitability index for each project if the cost of capital is 12%? 125 PV of future cash flows for A: 126 Pl of A: 127 128 PV of future cash flows for B: 129 PI of B 130 Build a Model READY Expected Net Cash Flow Project A Project B ($575) $190 $190 $190 $190 $190 $190 $0 ime 0 ($375) ($300) ($200) ($100) $600 $600 $926 1 2 3 4 5 7 ($200) tal is 12%, which project should be sel A B C H J K f. What is the regular payback period for these two projects? Project A Time period Cash flow Cumulative cash flow 0 1 2 3 5 6 7 (375) (300) (200) (100) 600 $600 $926 ($200) Intermediate calculation for payback Payback using intermediate calculations Project B Time period 0 7 1 2 4 5 6 Cash flow Cumulative cash flow Intermediate calculation for payback Payback using intermediate calculations Payback using PERCENTRANK Ok because cash flows follow normal pattern. dinnountod nauhack neriod for these two projects? ow normal pattern. 102 g. 103 104 WACC 105 106 Project A 107 At a cost of capital of 12%, what is the discounted payback period for these two projects? 12% - Time period Cash flow 0 2 3 4 5 6 7 108 109 Disc. cash flow 110 111 112 Payback using intermediate calculations 113 114 Project B 115 116 117 118 119 120 121 Discounted Payback using PERCENTRANK 122 Disc. cum. cash flow Intermediate calculation for payback Time period Cash flow Disc. cash flow 3 5 6 7 0 1 2 4 Disc. cum. cash flow Intermediate calculation for payback Payback using intermediate calculations Ok because cash flows follow normal pattern. 123 h. What is the profitability index for each project if the cost of capital is 12%? 124 125 PV of future cash flows for A: 126 PI of A: 127 128 PV of future cash flows for B: 129 PI of B: 130 131 132 Build a Model

Answer & Explanation Solved by verified expert

See Answer