EASY?? ill leave a good rating. PLEASE help. my question was answered but i need to use CELL REFERENCING so please solve and show how using cell referencing. good rating!! last pixture shows format i have to submit it in.

Note: 3 Calculation of Fixed assets sale: Note: 4 Increase in Net working Capital Amiya also had information from the finance group. A colleague in the treasury department informed Amlya 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 successful investments but also many investments that falled. Because of this, Forage typically used a discount rate of 17% when considering new investments. Fortunately for Amiya, a colleague sent her a template from a similar previous analysis, which would provide a starting point for Amiya (See Table 2). Depreciation table given: Table 1. Depreciation Schedule to Use for Purchased Assets Table Template that needs to be filled: Table 2. Template for Net Present Value (NPV) Analysis Explanation: Note:1 Sales are calculated on the basisi of Yo sale i.e. $550,000.00 Note: 2 Calculation of Depreciation Note: 3 Calculation of Fixed assets sale: Note: 4 increase in Net working Capital \begin{tabular}{|c|c|c|c|c|c|c|} \hline Year: & a & 1 & 2 & 3 & 4 & 5 \\ \hline Sales: & & $550,000.00 & $660,000.00 & $732,000.00 & $950,400.00 & $1,140,480.00 \\ \hline Fuet Operution Expenses: & & $95,000.00 & $104,500.00 & $114,95000 & $126,445.00 & $139,089.50 \\ \hline Vertable Operetins Fexplnues: & & coes & sath & $95,040.00 & $237,600,00 & $79,833.60 \\ \hline Deprediation: & & $19,000.00 & $33,440.00 & $22,070.40 & $14,546.46 & $8,011.56 \\ \hline Eart: & & & & $559,939.60 & $571,768.54 & $913,545.34 \\ \hline Tenes: & & & & $106,388.52 & $108,639.82 & $173,573,52 \\ \hline Md badk depreclation: & & & & & & \\ \hline Operatine Canh How: & & & & & & \\ \hline Foxed assets: & & & & & & \\ \hlineNW : & & & & & & \\ \hline Free Canh Fows: & & & & & & \\ \hline \end{tabular} NPV: Thet Fina Create a Microsoff Excol spreadsheet that calculates pro forma free cash fiows and the not present value. The spreadsheet should include 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 appropriately use cell referencing. The spreadsheet should also be dynamic in the sense that, if any of the inputs are changed, all of the cash flow and NPV calculations will automatically update. Situation: Preliminary discussions between executives at forage and Scoot-Ease suggested that the assets of ScootEase could be purchased for $1,350,000. Amiya was tasked with determining whether an acquisition at this price would create value for Forage. Fortunately for Amiya, these types of decisions were supported by many functions at Forage. Amiya received the following information; - In its most recent full fiscal year, Scoot-Ease generated $550,000 in revenue. Forage's marketing department expected this revenue to grow at 20%, year-over-year, for the foreseeable future. - The cost accounting 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, SG8A, and other of 12%,25%, and 27% of sales, respectively. Last, they e-mailed Amiya the depreciation schedule that should be used for the assets (see Table 1). - 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 offset 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 Amiya also had information from the finance group. A colleague in the treasury department informed ractice to hold net working capital (NWC) levels equal to 15% of expected \begin{tabular}{|c|c|c|c|c|c|c|} \hline Perticuinn: & Yo & Y1 & Y2 & Y3 & Y4 & Ys \\ \hline Sale (Note: 1) & & $660,000.00 & $792,000.00 & $950,40000 & $1,140,48000 & 51,368,576.00 \\ \hline Less: Fixed operating expenses & & $95,000.00 & $104,500.00 & $114,95000 & $126,445.00 & $139.08950 \\ \hline Lnss: Variable operating expenses & & & & & & \\ \hline Cost of goods soid & & $79,200.00 & $95,040.00 & $114,048.00 & 51.36,85760 & 5164,229.12 \\ \hline SGE A & & $165,000.00 & $198,00000 & $237,60000 & 5285,120.00 & $342,14400 \\ \hline Others & & $17,820,00 & $21,384.00 & $25,660.80 & $30,792,96 & $36,951.55 \\ \hline Depreciation (Note: 2 ) & & $270,000.00 & $345,600.00 & $141,004,80 & $68.359:13 & 560,484.16 \\ \hline EBIT & & $32,980.00 & $27,476.00 & $317,136,40 & 5492,905.31 & $625,677.67 \\ \hline Taxes e 19% & & $6,266.20 & $5,220,44 & 560,255,92 & $93,652.01 & 5118.878 .76 \\ \hline Earning after Tax & & $26,713.80 & $22,255.56 & $256,800.48 & $399,253.30 & 5506,798.94 \\ \hline \multicolumn{7}{|l|}{ Add: Non-Cash items } \\ \hline Depreciation & & $270,000.00 & $345,60000 & $141,00480 & $68,359.13 & 560,484.16 \\ \hline Operating Cash Flow & & $296,713.80 & $367,855.56 & $397,8a5.28 & $467,612.43 & $567,283.07 \\ \hline Fined Assets (Note 3 ) & & 5000 & $0.00 & 5000 & 50.00 & $493.264.86 \\ \hline increase in NWC (Note: 4) & & $16,500.00 & 519,80000 & 523,76000 & $28.512.00 & .534 .274 .40 \\ \hline Free cash fiows & 51.350,00000 & $280.213.80 & $348.055.56 & 5374,125,28 & 5439100.43 & $1,026,333.53 \\ \hline Decounting Factor if ins & 1.000 & 0.855 & 0.731 & 0624 & 0.534 & 0.456 \\ \hline Present Value & -5., 5000000 & 523949897 & $254.259.30 & $23359284 & $234,32597 & $468.2221 \\ \hline \end{tabular}