i know this is a super long question, but i have been struggling for about 3 days. not sure what else to do. if anyone woupd do this i woupd be so appreciative!! I NEED THIS ASAP!

thank you so much to anyone that woupd do this!

Socnario selling a new Designer Womens Topr line. The enaff of fanencial analyma had been working hard over the la few o celu collefefeg data and had prepared a midel creating a fiascial forecast about the propoved projech viebaing. excel spee dichet prepared for the prescntstion. What follows as sooe hase afermation that Slantel knew asd was able io fetrieve about the jroject. new Designer Womens Tops line. Doe to relatively rapil ahsaces in archalogy, the project was expected to be discentinaed in foar years. The new Desgner Womens Tops was expectod no sell for 5102 per unit and bad projected unles of 4400 anita in the firu year, with a projected (Mod-Likely scesario) 25.0% growth rate per year for miturqueat years. A toal investrent of 5792,000 for new ecuipment was required. The equipmeat had fined mainteasce ceneracts of 5346915 per year with a salvage valae of 5 122,863 and variable coss were 10% of revensec Surniel also seeded to coenisker both the Best-Case and Werit-Case senaries in the analysis with growth rates of 3500% and 2.30% remectively. working capital of $156,910 and $28,244 of tis increase woald be edisct with accounts payable. PSUWC currenty has 1053000 alases of dack outchanting at a cartent price of 75.00. Even though the company has oubtanding nock, it is pot publicly traded and Eerefore there an so pokichy swailahle finascial infermation. However, after analysis managemeat believes that its equity bea is 0.92. The company ako has 69000 bonds cubtandieg with a carreet price of 51,.927.00. The bonds pay interest semb-annually at a coapen rate of 5.40%. The bosde have a par valae of 51,000 asd will atare in 5 years. The average cerperate tax rake was 30% Management believes the SKP 500 is a reasonable proxy for the market portfolia. Therefore, the cost of equiry is calculated would calculate the monthly expecied market retarn aing Syears of pas noethy price data available in the worksheet Marketdata. This would then be muliplied by 12 to cainate the assual expected rase. Shantel remembered that if the expected rate of tearn for the market was loo low, noo high, of ne gation, a forward looking rase of an historical average of about 9.5% ? would have to be abed, as the calculated value for the curreat 5.year periad may not be rspersentative of the fuare. Shaatel was on as aenual basic. Shaskl needed to cakulate the raie at which the project wodif have wo he discounted to calculase the Net Present Value (NPV) of the proposed project besed on the decisice of raining capital and tere cerrent capial market environment. This discount ratie, the WAOC, would obvioualy influcnce the NIV and coald affect te decilioe of whether to accept ar reject the project. Thankfully, all the information pecded wo cakcolate tiks was availbtie. Sunsel needed wo clearly show all the calculations and sources for all perameter ertimates used in the calculation of the WNCC (and altimately the NPV). Gathering all the available information, Shantel got a large cup of eatra itrong coffee aad at down to work ce the development of the Cupital Budgeting project model. The correct recenncalstioe so the board was critical to the funure growith of the firml Shantel appreciated the detaled step by sep inatruc tioas ee te Worluhcet 0. Cane Inaructives - Luckily they were seill availablett. Note 1 Please use apprepriate Cell referescing in Fxcel ai that your numerical valacs update when yoa change any input(o). This will be helpiol when yeu analy oo the Best and Wors Case zreveth rate scesarion. Numerical Inputs expected from you are hizhlightcd in yellow and Formular Fanction lnputs are highighted in blue. Step 1: Read the Full Case. On the "Capitalkudger" Werkitheet Step 2: Calculate the weights of Equity and Weights of Debt for the firm. Use the wock and hond data provided in the care. Step 3: Calculate the Cont of Equity for the firm. Use the CAPM and the Market data provided on en the Work sheet "MarketData". Step 4: Calculate the Cost of Debt for the firm. Uwe the information provided about the firms bondr to calculate the YTM. 5tep 5: Calculate the after-tax sost of debt. Use the given tax rate for the firm. Step 6: Use the results from steps 2.5 to calculate the WACC (Weighted Average Cont of Copital) for the firm, Sitp 7: inpat the appropriate Initial Cash Outlays MPPORTANT: All cash infowi need to te POSITHE asd all cash oueflon need fo be NECATHE. Step 8: Input the appropriate Cash flows from Operations Step 9: Input the appropriase Terminal Cash flows. Step 10: Compate the Net Cach fows for Years 0 - 4 . Step 12: Compute the NTV of the Netcash fows - This can be dose as the sum of the PV' in Step If or using Hixcels NiVY formula. Seen 13: Indicale the Acceptreject decision for the most likely seenario. Siep 14: Compute the NPV for tae Best Case scenarie by changing to the Best Case growth rate in cell Bt1 and indicato the Accept/Reject Decition for thas kenario- See Nake 1 abeve - Thir a shere if will be helphel. Step 15: Consuie the NPV for the Worst Case scenarie by changing to the Wors Cave growht rate in cell B11 and indicate tbe AcoeptReject Decisios for this scenario. On the "NPBPrefite" Wericheet Step 16: Complese the table to renerate a NVY profte for the Mod-Likely Soenario. The graph will be watomatically generated for you. Step 17. Optional - Complete the Worksheet "Anawer Sheer" as needed. (wee instructions on the abeet Hint Fiphinclarify any absumptieas of methods used. Note: Use this sheet to convey any comments to the instructer. Step I B: Double elackik your wark Suen 19: Save with Solutions for Most Likely Case and Upload your final ilxcel project by the due date. that you may wish to conduct 1. Given the following data on proposed capital budgeting project