What is the maturity value of the loan using ordinary interest? $
What is the maturity value of the loan using exact interest?
Round your answer to two decimal places. $
ch10ex02 [Modo de compatibilidad] - Excel Archivo inicio Insertar Diseo de pgina Frmulas Datos Revisar Vista Qu desea hacer? Empe Urbina Compartin | Chapter 10-Exercise 02 Chapter 10 - Exercise 02 Simple $12,000 1/15/2011 10% Ordina 4 Principal 5 Loan Date 6 Rate $12,000 1/16/2011 10% 180 Exact 12,000 1/17/2011 10% Time 9 Interest 10 Maturity Value 11 Due Date 12 13 Directions: 1 a. You want to borrow $12,000 for 24 months at a rate of 10% In Cell B9, enter the formula to compute the Simple Interest (Principal times Rate times Time divided by 12) 14 b. You decide to change the length of pay-back time to 180 days In Cell C9, enter the formula to calculate Ordinary Interest 15 (Principal times Rate times Time divided by 360). C. Now you decide to change the length of time to 60 days. In Cell D9, enter the formula in Cell D9 to calculate Exact Interest (Principal times Rate times Time divided by 365). 16 d. In Cells B10 through D10, enter formulas to compute the Maturity Value (Principal times the result of 1 plus Rate times Time divided by months or days). 17 18 e. In Cell B11, enter the Due Date of 1/15/2013 (1/15/2011 plus 24 months). ch10ex02.xlsx Listo - +100% 6:09 PM O Type here to search RENG 3152019 ch10ex02 [Modo de compatibilidad] - Excel Archivo inicio Insertar Diseo de pgina Frmulas Datos Revisar Vista Qu desea hacer? Empe Urbina Compartin A1 | Chapter 10-Exercise 02 6 Rate 10% 24 10% 180 da 10% Time 9 Interest 10 Maturity Value 11 Due Date 12 13 Directions: a. You want to borrow $12,000 for 24 months at a rate of 10% In Cell B9, enter the formula to compute the Simple Interest (Principal times Rate times Time divided by 12). 14 b. You decide to change the length of pay-back time to 180 days. In Cell C9, enter the formula to calculate Ordinary Interest 15 (Principal times Rate times Time divided by 360). C. Now you decide to change the length of time to 60 days. In Cell D9, enter the formula in Cell D9 to calculate Exact Interest (Principal times Rate times Time divided by 365) d. In Cells B10 through D10, enter formulas to compute the Maturity 16 Value (Principal times the resuit of 1 plus Rate times Time divided by months or days). e. In Cell B11, enter the Due Date of 1/15/2013 (1/15/2011 plus 24 months). 17 18 19 f. In Cells C11 and D11, compute the Due Date (Loan Date plus Time g. Format dollar amounts for Currency, 2 Decimal places, and $. 20 Format date entries for Date xxx/xxxx. 21 h. Save the file as ch10ex02a.xisx. ch10ex02.xlsx - +100% 6-10 PM O Type here to search 3152019 ch10ex01 [Modo de compatibilidad] - Excel Archivo inicio Insertar Diseo de pgina Frmulas Datos Revisar Vista Qu desea hacer? Empe Urbina Compartin | Chapter 10-Exercise 01 Chapter 10 Exercise 01 4 Principal 5 Loan Date 6 Rate Ordina $5,000 5/11/2011 10% 160 Exact $5,000 5/12/2011 10% Time 9 Interest 10 Maturity Value 11 Due Date 12 13 Directions: a. You want to borrow $5,000 for 3 months at a rate of 10% In Cell B9, enter a formula to compute the Simple Interest (Principal times Rate times Time divided by 12) 14 b. You decide to change the length of pay-back time to 160 days In Cell C9, enter a formula to calculate Ordinary Interest 15 (Principal times Rate times Time divided by 360) c. Now you decide to change the length of time to 90 days. In Cell C9, enter a formula to calculate Exact Interest (Principal times Rate times Time divided by 365). 16 d. In Cells B10 through D10, enter formulas to compute Maturity Value (Principal times the result of 1 plus Rate times Time divided by months or days). 17 18 e. In Cell B11, enter the Due Date of 8/10/2011 (5/10/2011 plus 3 months). ch10ex01.xlsx Listo - +100% O Type here to search 6-12 PM 3152019 ch10ex01 [Modo de compatibilidad] - Excel Archivo inicio Insertar Diseo de pgina Frmulas Datos Revisar Vista Qu desea hacer? Empe Urbina Compartin A1 | Chapter 10-Exercise 01 6 Rate 10% 10% 160 da 10% Time 9 Interest 10 Maturity Value 11 Due Date 12 13 Directions: a. You want to borrow $5,000 for 3 months at a rate of 1 096. In Cell B9, enter a formula to compute the Simple Interest (Principal times Rate times Time divided by 12). b. You decide to change the length of pay-back time to 160 days. 14 In Cell C9, enter a formula to calculate Ordinary Interest 15 (Principal times Rate times Time divided by 360). C. Now you decide to change the length of time to 90 days. In Cell C9, enter a formula to calculate Exact Interest (Principal times Rate times Time divided by 365) d. In Cells B10 through D10, enter formulas to compute Maturity Value 16 (Principal times the result of 1 plus Rate times Time divided by 17 months or days). 18 e. In Cell B11, enter the Due Date of 8/10/2011 (5/10/2011 plus 3 months). 19 f. In Cells C11 and D11, compute the Due Date (Loan Date plus Time g. Format dollar amounts for Currency, 2 Decimal places, and $. 20 Format date entries for Date xxx/xxxx. 21 h. Save the file as ch10ex01a.xisx. ch10ex01.xlsx - +100% O Type here to search 6-13 PM 3152019
