answer question 5 a, b, c and 6 a, b, c please

Instructions-Np-EX16-9: Word es Mailings Review View Help Tell me what you want to do 5. Switch to the Amortization worksheet. Calculate the curnulative interest for a loan for one food truck as follows: In cell C17, enter a formula using the CUMIPMT function to calculate the cumulative interest paid on the loan after the first year (payment 1 in cell C15 through payment 12 in cell C16) when the payments are made at the end of the period. Use O as the type argument in your formula. a. b. c. d. Use absolute references for the rate, nper, and pv arguments. Use relative references for the start and end arguments. Copy the formula from cell C17 to the range D17:G17 to calculate the interest paid in Years 2-5. Calculate the cumulative principal for a loan for one food truck as follows: 6. In cell C18, enter a formula using the CUMPRINC function to calculate the cumulative principal paid in the first year (payment 1 in cell C15 through payment 12 in cell C16) when the payments are made at the end of the period. Use O as the type argument in your formula. a. b. c. d. Use absolute references for the rate, nper, and pv arguments. Use relative references for the start and end arguments. Copy the formula from cell C18 to the range D18:G18 to calculate the principal paid in Years 2-5. In cell H18, use the Error Checking command to identify the error in the cell, and then correct the error. (Hint: The formula in the cell should calculate the total the values in C18:G18 using the SUM function.) Calculate the principal amounts in the loan amortization schedule as follows: 7. 8. In cell E23, enter a formula using the PPMT function to determine the amount of the first loan payment devoted to principal. a. b. Use absolute references only for the rate, nper, and pv arguments Use cell A23 as the current period. (Hint: The period is based on a monthly payment schedule.) Copy the formula from cell E23 to the range E24:E82 to calculate the d. Instructions NP EX16 9a Word Tell me what you want to do View Mailings Review Help es Copy the formula from cell E23 to the range E24:E82 to calculate the principal paid in Periods 2-60. d. 1 le sa Proect to New Perspectives Excel 2016: 1 Module RSAMPr Calculate the ihterest amounts in the loan amortization schedule as follows: a. In cell F23, enter a formula using the IPMT function to determine the b. Use absolute references only for the rate, nper, and pv arguments. c. Use cell A23 as the current period. (Hint: The period is based on a 9. amount of the first loan payment devoted to interest. monthly payment schedule.) d. Copy the formula from cell F23 to range F24:F82 to calculate the principal paid in Periods 2-60. 10. Switch to the Depreciation worksheet. Calculate the annual straight-line depreciation for one new food truck (the most likely scenario) as follows a. In cell C11, enter a formula using the SLN function to calculate the b. Use the values in cells DS, D6, and D? for the arguments c Use absolute references for the cost, salvage: and life arguments in the dCopy the formula from cell Cli to the range DIi :1 to caiculate the straight-line depreciation for the truck during its first year of service SLN formula yearly straight line depredation inears 2 Enew View Help Tell me what you wa Cut |Franklin Gothic Bell! 'Ka" EeCopy . 9- "Wrap Text Currency Format Painter Clipboard Font Alignment C17 1 Mobile Vegan Expansion Plan 2 zation Schedule 4 Conditions 5 Loan amount (pv) 6 Annual interest rate 7 Monthly interest rate (rate) 8 Loan period in years 9 Loan period in months (nper) 10 Monthly Payment Due Add 1 Truck 56,000 4 50% 042% (S1.057) 1/2/2019 1 Start date of loan 3 Cumulative Interest and Principal Payments per Year Year 5 Year 3 25 36 Year 4 37 48 Year 2 13 24 Year 1 Total c0 nterest $56,000 $56,000 $56.000 58000$56,000 9 Principal Remainingl Documentation Loan Scenarios Amortization Depreciation income statement ype here to search . P EX16, FURNERMARQUIS 1 Ex Insert Page Layout Formulas Data Review View Help ell me what you want to do Home Cut E) Copy , I wrap Tent Currency Merge & Center . | $ . % , Format Painter Clipboard Font Alignment Number C17 Mobile Vegan Expansion Plan 2 zation Schedule 4 Conditions 5 Loan amount (pv) 6 Annual interest rate Add 1 Truck 56,000 450% 042% Monthly interest rate (rate) 8 Loan period in years 9 Loan period in months (nper) 10 Monthly Payment Due 11 Start date of loan 60 $1.057) 1/2/2019 19 Principal 20 21 Amortization Schedule S56 0001 enan ng S56 000 S56,000 1 $86,000 $56,000, Beginning Balance Ending Cumulative Date Payment PrincipalInterest Balance S 56,000.00 $ 58,000 00 $ $ 56,000.00 S 56,000 00 5 56,0000o s Interest 1/2/2019 $ 56,000 00 $ 05679) 2/1/2019 $ 56.000.0011056.79) 3/1/2019 56,000.00 5 1.056.79 4/1/2019 56,000.00 s 1.056.79 5/1/2019 56,000 00 1.056 79 27 Loan Scenarios Amortization Depreciation Income Statement Investment Type here to search Instructions-Np-EX16-9: Word es Mailings Review View Help Tell me what you want to do 5. Switch to the Amortization worksheet. Calculate the curnulative interest for a loan for one food truck as follows: In cell C17, enter a formula using the CUMIPMT function to calculate the cumulative interest paid on the loan after the first year (payment 1 in cell C15 through payment 12 in cell C16) when the payments are made at the end of the period. Use O as the type argument in your formula. a. b. c. d. Use absolute references for the rate, nper, and pv arguments. Use relative references for the start and end arguments. Copy the formula from cell C17 to the range D17:G17 to calculate the interest paid in Years 2-5. Calculate the cumulative principal for a loan for one food truck as follows: 6. In cell C18, enter a formula using the CUMPRINC function to calculate the cumulative principal paid in the first year (payment 1 in cell C15 through payment 12 in cell C16) when the payments are made at the end of the period. Use O as the type argument in your formula. a. b. c. d. Use absolute references for the rate, nper, and pv arguments. Use relative references for the start and end arguments. Copy the formula from cell C18 to the range D18:G18 to calculate the principal paid in Years 2-5. In cell H18, use the Error Checking command to identify the error in the cell, and then correct the error. (Hint: The formula in the cell should calculate the total the values in C18:G18 using the SUM function.) Calculate the principal amounts in the loan amortization schedule as follows: 7. 8. In cell E23, enter a formula using the PPMT function to determine the amount of the first loan payment devoted to principal. a. b. Use absolute references only for the rate, nper, and pv arguments Use cell A23 as the current period. (Hint: The period is based on a monthly payment schedule.) Copy the formula from cell E23 to the range E24:E82 to calculate the d. Instructions NP EX16 9a Word Tell me what you want to do View Mailings Review Help es Copy the formula from cell E23 to the range E24:E82 to calculate the principal paid in Periods 2-60. d. 1 le sa Proect to New Perspectives Excel 2016: 1 Module RSAMPr Calculate the ihterest amounts in the loan amortization schedule as follows: a. In cell F23, enter a formula using the IPMT function to determine the b. Use absolute references only for the rate, nper, and pv arguments. c. Use cell A23 as the current period. (Hint: The period is based on a 9. amount of the first loan payment devoted to interest. monthly payment schedule.) d. Copy the formula from cell F23 to range F24:F82 to calculate the principal paid in Periods 2-60. 10. Switch to the Depreciation worksheet. Calculate the annual straight-line depreciation for one new food truck (the most likely scenario) as follows a. In cell C11, enter a formula using the SLN function to calculate the b. Use the values in cells DS, D6, and D? for the arguments c Use absolute references for the cost, salvage: and life arguments in the dCopy the formula from cell Cli to the range DIi :1 to caiculate the straight-line depreciation for the truck during its first year of service SLN formula yearly straight line depredation inears 2 Enew View Help Tell me what you wa Cut |Franklin Gothic Bell! 'Ka" EeCopy . 9- "Wrap Text Currency Format Painter Clipboard Font Alignment C17 1 Mobile Vegan Expansion Plan 2 zation Schedule 4 Conditions 5 Loan amount (pv) 6 Annual interest rate 7 Monthly interest rate (rate) 8 Loan period in years 9 Loan period in months (nper) 10 Monthly Payment Due Add 1 Truck 56,000 4 50% 042% (S1.057) 1/2/2019 1 Start date of loan 3 Cumulative Interest and Principal Payments per Year Year 5 Year 3 25 36 Year 4 37 48 Year 2 13 24 Year 1 Total c0 nterest $56,000 $56,000 $56.000 58000$56,000 9 Principal Remainingl Documentation Loan Scenarios Amortization Depreciation income statement ype here to search . P EX16, FURNERMARQUIS 1 Ex Insert Page Layout Formulas Data Review View Help ell me what you want to do Home Cut E) Copy , I wrap Tent Currency Merge & Center . | $ . % , Format Painter Clipboard Font Alignment Number C17 Mobile Vegan Expansion Plan 2 zation Schedule 4 Conditions 5 Loan amount (pv) 6 Annual interest rate Add 1 Truck 56,000 450% 042% Monthly interest rate (rate) 8 Loan period in years 9 Loan period in months (nper) 10 Monthly Payment Due 11 Start date of loan 60 $1.057) 1/2/2019 19 Principal 20 21 Amortization Schedule S56 0001 enan ng S56 000 S56,000 1 $86,000 $56,000, Beginning Balance Ending Cumulative Date Payment PrincipalInterest Balance S 56,000.00 $ 58,000 00 $ $ 56,000.00 S 56,000 00 5 56,0000o s Interest 1/2/2019 $ 56,000 00 $ 05679) 2/1/2019 $ 56.000.0011056.79) 3/1/2019 56,000.00 5 1.056.79 4/1/2019 56,000.00 s 1.056.79 5/1/2019 56,000 00 1.056 79 27 Loan Scenarios Amortization Depreciation Income Statement Investment Type here to search