Question: please help me!! this is the excel formula that was attatched. let me know if you need any more information you can use your own



Excel Online Structured Activity: Capital budgeting criteria A company has a 13\% wACC and is considering two mutuethy exclusive investments (that rannet be repeated) with the fotiowing cash fows: The data has been collected in the Microsor Excel Derline fie belew. Open the spreadsheet and perform the required analysis to answer the questons below. a. What is each project's NPVT Round your answer to the hearest cent. bo net reund your intermedale caiculations. Project A: 3 Preject Bis b. What is each project's tRA? Round your answer to two decimal places. Froject A : Prefect 6: c. What is each projects Mitur (Wint: Consider Peripd 7 as the end of Project By Mle.) found your answer to two decimal places. Do not round yeur intermedlate calculabqhs Freject A: Preject 6 c. What is each projects MikR? (Hint: Conbider Perlod 7 an the end of Pmoject B's lfe.) kourd your answer to two dedimal plsces. Do not round yeur interinediate ealculatons. Project A: Project B: d. From your answers to parts a-c, which project would be Miected? If the wacC was 18%, which preject would be seledted? 2. Construct NPV profies for Projects A and B. Round your answers to the nearest cent, Do not round your intermediate Caiculetions. Negative value shoujd be incicated by a minu 9. What is each project's Mint at a WAcC of 166 ? lsund your anseer to two decimal places. Do nat reund your intermediate calculabons. Project A: Project : 3. nax i) 1. hryad II it migmenry Cotuminen II hesk 111 14 sin is is husia It Wit wier ioutio in) Piethe pouts it) hid ver rotro NPV Profiles
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
