PLEASE help me answer this using cell referencing/showing the formulas how to answer each problem/how you got each answer with the cell referencing formulas showing. the last picture shows the template and format the excel should be in. thank u so mych i will rate good if its right!

The Scoot-Ease Acquisition Analysis - Part One 1. Introduction Fresh out of the Carson College of Business, Amiya Perez stepped into her role as a financial analyst at Forage, a respected information fecthology conglomerate, equipped with ambition and an impressive educational background. Before she could even get accustomed to her new office chair, she was assigned a complex and high-stakes tack - to present to the board of directors an analytical assessmemt of the net present value (NPV) of acquiring the assets of Scoot-Ease lnc, a pay-by-the-hour electronic scooter rental company. Suddenly, Amiya was thrust into a pivotal role that could potentially shift her firn's standing in the competitive micronobility market. 2. Background Secot-Ease Inc., a provider of pay-per-bour clectronic scooter rentals, had enjoyed initial saceess with its unique business model and insovative technology. However, despite its initial promise, Scoot-Ease faced mounting competition and regulatory challenges, limiting this small player's ability to generate profits. Forage saw a potential opportunity. They believed acquiring the assets of Scoot-Ease would provide the company with an entry point into the micromobilify market, leveraging Forage's name recognition with consumers and scale to reach profitability. In addition, Scoot-Fase's operations are currently located in Los Angeles and Las Vegas, two of the many markets in which Forage operates. Moreover, the GPS tracking built into the scooters would provide Forage with important information about consumer pattems that would inform some of Forage's other businesses and potentially lesd to greater fevense getheration across these businesses. 3. Acquisition Estimates Preliminary discussions between executives at Forage and Scoot-Fase suggested that the assets of Seoot-Ease could be purchased for $1,350,000. Amiya was tasked with determining whether an acquisition at this price woald create value for Fonge. Fortunately for Amiyz, these types of decisions were supported by many functions at Forage. Amiya received the following information: - In its most reoent full fiscal year, Scoot-Ease generated $50,000 in revenue. Forage's marketing department expected this revenae to grow at 20%, year-over-year, for the foresecable future. - The cost acoounting group provided Amiya with the following cost estimates: Fixed operating expenses of $95,000 in the first year that will grow at 10% in future years. Variable operating expenses for cost of goods sold, SGA.A, and other of 12%,25%, and I 7% of sales, respectively. Last, they e-mailed Amiya the depreciation sehedule that should be used for the assets (see Table 1). - The coonomics department provided an estimate that the assets purchased would be productive for Forage for about five years. At that time, all of the assets would be sold at an estimated sales price of $00,000. 7% of sales, respectively. Last, they e-mailed Amiya the deprociation schedule that should be used for the assets (see Table I). - The economics department provided an estimate that the assets purchased would be productive for Forage for about five years. At that time, all of the assets would be sold at an estimated sales price of $500.000. - The tax group provided Amiya with a projected marginal tax rate of 19% to use for profits and any capital gain or loss on the sale of assets. They also reminded Amiya that individual projects could have negative taxes if the taxable income were to be negative because these tax losses would offict other taxable income from other divisions in Forage. Amiya also had information from the finance group. A colleague in the treasury department informed Amiya that it was company practice to hold net working capital (NWC) levels equal to 15% of expected sales. Forage was a fast-growing information technology company, with many socessful investments but also many investments that failed. Because of this, Forage typically used a discount rate of 17 \% when considering new investments. Foetunately for Amiya, a colleague sent her a template from a similar previous analysis, which would provide a starting point for Amiya (Sec Table 2). 4. Analysis Amiya now has the responsibility to compile and analyze peo forma free cash flows and NPV of the Scoot-Ease acquasition using the gathered information. She will send an Excel spreadsheet to her supervisor that contains her analysis. Assignment Details: 1. You will act as Amiya and sreate a Microsoft Excel sprcadshect that calculates pro forma free cash flows and the net present value of the acquisition of the assets of Scoot-Ease, Inc. The spreadsheet will be presented by Amiya's supervisor to the board of directors, and Amiya will be pessent. The spreadsheet should inclade all of the inputs necessary to calculate free cash flows and NPV based on the information provided. Further, the spreadsheet should be formula-based and appeopriately use cell referencing. The spreadshect should also be dynamic in the sense that, if any of the ispots are changed, all of the cash flow and NPV calculations will automatically update. 2. Your completed spreadshert aust be uploaded to Canvas by 11:59 PM on December 14,2023. 3. This is part one of a two-part project. Fach part of the project is equally weighted. The grade for this part of the project will be axsigned as follows: 50% based on the accurecy of the calculations in the spreadsheet; 30%6 based on whether the spreadsheet appropriately used formulas and cell-referencing to be dynamic; 20% on the formatting and visual presentatioe of the spreadshect (is the specadshoct formatted in a way that you would be comfortable showing the boand of directors of your company?). grade for this part of the project will be assigned as follows: 50% based on the accuracy of the ealculations in the spreadsheet; 30% based on whether the spreadsheet appropriately used formulas and cell-referencing to be dynamic; 20%6 on the formatting and visual presentation of the spreadsheet (is the spreadsheet formatted in a way that you would be comfortable showing the board of directors of your company?). 2 Table 1. Depreciation Sehedule to Use for Purchased Assets Table 2. Template for Net Present Value (NPV) Analysis \begin{tabular}{|c|c|c|c|c|c|c|c|c|} \hline 4 & A & B & c & o & E & F & G & H \\ \hline 1 & Year: & 0 & 1 & 2 & 3 & 4 & 5 & \\ \hline 2 & Sales: & & & & & & & \\ \hline 3 & Fixed Operation Expenses & & & & & & & \\ \hline 4 & Variable Operating Expenses & & & & & & & \\ \hline 5 & Depreciation & & & & & & & \\ \hline 6 & EBIT & & & & & & & \\ \hline 7 & Taxes & & & & & & & \\ \hline 8 & Add back depreciation & & & & & & & \\ \hline 9 & Operating Cash Flow & & & & & & & \\ \hline \multicolumn{9}{|l|}{10} \\ \hline 11 & Fixed assets & & & & & & & \\ \hline 12 & NWC & & & & & & & \\ \hline 13 & Free Cash Flows & & & & & & & \\ \hline \multicolumn{9}{|l|}{14} \\ \hline 15 & NPV & & & & & & & \\ \hline \multicolumn{9}{|l|}{16} \\ \hline 17 & & & & & & & & \\ \hline 18 & & & & & & & & \\ \hline \end{tabular}