Question: PLEASE HELP!! URGENT!! 1. Given the following data on proposed capital budgeting project. (Numerical Inputs Expected from you are highlighted in yellow and Formula/Function Inputs

 PLEASE HELP!! URGENT!! 1. Given the following data on proposed capital

PLEASE HELP!! URGENT!!

1. Given the following data on proposed capital budgeting project. (Numerical Inputs Expected from you are highlighted in yellow and Formula/Function Inputs are highlighted in blue) Parameters Economickofprown Market Value of Equity S 74.752.000.00 of Shares Dandia 1024000 Price of New Feet 127.790.00 Marku Vabee of S 91.630,000.00 A of Beads Obitandis 98000 Chanel NWC Total Marku Vaba 5166,382,000.00 Market Price of Bands s 935.00 s 356 01100 We hof Eet 44.93 Market Price of Stack s 73.00 Variable Cast of Rura) 1354 Weight of the S5.079 Salvage value of New Equipment s 144.617.00 ER 9.50% Marginal Tax Rate 30.0% RE 1.4 |Band Ins Pravilai ar ar arrience First Year Lalit Sale 4900 0.91 Years in Mal 14 Sales Corowa Rate 18.00% Cast of Equity or 12.355PMT Walt Sale Price 117.00 Cast of the 0.04%|FV 57,00 First Year He Afer Tax Cost of the 2.84 Bofare tax YTM WACO 7.099 Boare fax YTM ? Note Cells C21 and 22 include the initial (today's) cash flows. Colume through Gare the operating cash Bows Spreadsheet for determining Cash Flows Calls 38-G40 centain the brimal cash flaws. Year 0 3 II. Net lavet Oday Initial CF Price of Equipo S 20.007 Change in NWC M. Cash Flows from Oras Remeration La Salo 4900 Laat Sale Price 117.00 Revenues 573.300.00 Casita Ville Cost Fixed Cost Depecon Fenings Before Taxes To Net home | Deprai | Net IV. Terminal Cash Flow Saare Value Tax on Sulae Value Reum of NWC V. Final Cash Flow Cash Flows Present Value ofCFX NPV Accept? NPV of Project Summarize Answers for NPV under three cases in area below Sal Growth Rae 28.0% Best Case 18.00% Most Likely 1.8% Werst Cove 1. Given the following data on proposed capital budgeting project. (Numerical Inputs Expected from you are highlighted in yellow and Formula/Function Inputs are highlighted in blue) Parameters Economickofprown Market Value of Equity S 74.752.000.00 of Shares Dandia 1024000 Price of New Feet 127.790.00 Marku Vabee of S 91.630,000.00 A of Beads Obitandis 98000 Chanel NWC Total Marku Vaba 5166,382,000.00 Market Price of Bands s 935.00 s 356 01100 We hof Eet 44.93 Market Price of Stack s 73.00 Variable Cast of Rura) 1354 Weight of the S5.079 Salvage value of New Equipment s 144.617.00 ER 9.50% Marginal Tax Rate 30.0% RE 1.4 |Band Ins Pravilai ar ar arrience First Year Lalit Sale 4900 0.91 Years in Mal 14 Sales Corowa Rate 18.00% Cast of Equity or 12.355PMT Walt Sale Price 117.00 Cast of the 0.04%|FV 57,00 First Year He Afer Tax Cost of the 2.84 Bofare tax YTM WACO 7.099 Boare fax YTM ? Note Cells C21 and 22 include the initial (today's) cash flows. Colume through Gare the operating cash Bows Spreadsheet for determining Cash Flows Calls 38-G40 centain the brimal cash flaws. Year 0 3 II. Net lavet Oday Initial CF Price of Equipo S 20.007 Change in NWC M. Cash Flows from Oras Remeration La Salo 4900 Laat Sale Price 117.00 Revenues 573.300.00 Casita Ville Cost Fixed Cost Depecon Fenings Before Taxes To Net home | Deprai | Net IV. Terminal Cash Flow Saare Value Tax on Sulae Value Reum of NWC V. Final Cash Flow Cash Flows Present Value ofCFX NPV Accept? NPV of Project Summarize Answers for NPV under three cases in area below Sal Growth Rae 28.0% Best Case 18.00% Most Likely 1.8% Werst Cove

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Finance Questions!