Grader - Instructions Exced 2022 Project \begin{tabular}{|c|c|c|} \hline Step & Instructions & \begin{tabular}{c} Points \\ Possible \end{tabular} \\ \hline 10 & \begin{tabular}{l} The Declining balance depreciation assumes that the value of an assef depreciates more in \\ the first year than in the second year. In cell I17, calculate the declining-balance depreciation \\ value of the building for year ane and copy the formula down through year 7 . \end{tabular} & 10 \\ \hline 11 & In cells J17:J23, calculate the accumulated depreciation amount for each year. & 10 \\ \hline 12 & In cells K17:K23, calculate the book value of the asset at the end of each year of its useful life. & 10 \\ \hline 13 & \begin{tabular}{l} Select cells 123:K23, click the Border arrow in the Font group, and then click Thick Bottom \\ Border. \end{tabular} & 1 \\ \hline 14 & Save the workbook, exit Excel, and then submit the file as directed by your instructor. & 0 \\ \hline & Total Points & 100 \\ \hline \end{tabular} eps to Perform: Instructions Step \begin{tabular}{|c|c|} \hline 1 & \begin{tabular}{l} Start Excel. Download and open the file named \\ Expel_Ch11_PS1_New lavestment_Anabsis dox. Grader has automatically added your lsast, \\ name to the start of the filename. Save the file to the location where you are storing your files. \end{tabular} \\ \hline 2 & \begin{tabular}{l} On the BuildingAnalysis worksheet in cell C5, calculate the amount to finance by subtracting \\ the starting capital from the purchase price of the building. \end{tabular} \\ \hline 3 & \begin{tabular}{l} The payment amount returned by the PMT function includes principal and interest but no \\ taxes, reserve payments. private mortgage insuranoe, or fees that may be associated with the \\ loan. No fees will be considered at this time. In cell C10, calculate the end of period quarterty \\ payment amount using the PMT function. Be sure the result is displayed as a positive number. \end{tabular} \\ \hline 4 & \begin{tabular}{l} The cumulative interest payment function can be used to calculate the amount of interest paid \\ over a specific number of periods, such as quarterly, annually, or for the whole term of the \\ loan. In cell C11, calculate the total cumulative interest that will be paid on the loan for all 28 \\ end-of-the-period quarterty payments. Format as Currency. Be sure the result is displayed as \\ a posifive number. \end{tabular} \\ \hline 5 & \begin{tabular}{l} In cell C13, calculate the total cost of the loan by adding the amount financed to the total \\ cumulative interest. \end{tabular} \\ \hline 8 & \begin{tabular}{l} The net present value function, or NPV function, is used to determine the value of an \\ investment by analyzing a series of future incorning and outgoing cash flows that are expected \\ to occur over the life of the investment. In cell F13, calculate the net present value of the \\ investment using the NPV function. Format as Currency with 2 decimal places, if necessary. \end{tabular} \\ \hline 7 & \begin{tabular}{l} The straight-line depreciation value is the simplest and gost spminonly used method. It \\ assumes that the value of the asset loses the same amount of value each year of its life. In \\ cell 17 , calculate the straight-fine depreciation value of the building for year one and copy the \\ formula down through year 7 . \end{tabular} \\ \hline 8 & In cells J7:J13, calculate the accumulated depreciation amount for each year. \\ \hline 8 & \begin{tabular}{l} The net book value is equal to the original cost of the asset minus depreciation and \\ amortization. in cells K7K13, calculate the book value of the asset at the end of each year of \\ its useful life. \end{tabular} \\ \hline \end{tabular} A 1 fo 1. 21 3 4 s Amount to Firance APR (Rate) 6. 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 2221 23 24 \begin{tabular}{|c|c|c|c|} \hline \multicolumn{2}{|c|}{ Loan Analvis: } & \multicolumn{2}{|c|}{ Investment Analysis } \\ \hline Purchase Price & $280,000 & Initial linvestment & ARR \\ \hline \multirow[t]{2}{*}{ Starting Capital } & \multirow[t]{2}{*}{5187,500} & ($280.000) & 21% \\ \hline & & Year & Cash Flows: \\ \hline Amount to Finance. & $92,500,00 & 0 & {5280,000} \\ \hline APR (Rate) & & 1 & $96,000 \\ \hline Term (in vean) & 7 & 2 & $104,000 \\ \hline \multirow[t]{2}{*}{ Periods Fer Yeat } & \multirow{5}{*}{$6,66512} & 3 & $111,000 \\ \hline & & 4 & $79,000 \\ \hline Quartierly Payment & & 5 & $52,500 \\ \hline \multirow[t]{2}{*}{ Total Cimulatwe interest. } & & 6 & $36,000 \\ \hline & & 7 & $25,000 \\ \hline Total Cont of toan & 52.50000 & NPV. & 50.00 \\ \hline \end{tabular} c D. \begin{tabular}{|c|c|} \hline E & F \\ \hline \multicolumn{2}{|c|}{ Investment Analysis } \\ \hline Initial linvestment & RRR \\ \hline($280.000) & 2116 \\ \hline Year & Cash Flows \\ \hline 0 & (3280,000) \\ \hline 1 & $96,000 \\ \hline 2 & $104,000 \\ \hline 3 & $111,000 \\ \hline 4 & $79,000 \\ \hline 5 & $52,500 \\ \hline 6 & $36,000 \\ \hline 7 & $25,000 \\ \hline NPV & 50.00 \\ \hline \end{tabular} G. 1 J Asset information \begin{tabular}{|c|c|c|c|} \hline Initial Cost & Salvage Value & Uxefultufe & \\ \hline$280,000 & 598,237 & 7 & \\ \hline \multicolumn{4}{|c|}{ Straiert Line Depreciation } \\ \hline Vear & \begin{tabular}{c} Yearly \\ Depreciation \\ Expense \end{tabular} & \begin{tabular}{l} Accumulated \\ Depreciation \end{tabular} & Book value \\ \hline 1 & & & \\ \hline 2 & & & \\ \hline 3 & & & \\ \hline 4 & & & \\ \hline 5 & & & \\ \hline 6 & & & \\ \hline 7 & & & \\ \hline \end{tabular} Declinire Batance Deprecution Yearly Depreclation Accuimulated Expense Deprriation Book value