What are the banks proceeds from the $28,000 loan in part B? $

What are the banks proceeds from the $28,000 loan in part B? $

ch10ox07 [Modo de compatibilidad]- Excel Archivo inicio Insertar Diseo de pgina Frmulas Datos Revisar Vista Qu desea hacer? Empe Urbina Compartr A1 | Chapter 10-Exercise 07 Chapter 10-Exercise 07 3 A. Calculate simple, ordinary, and exact interest. Simple Ordinary 6 Principal 7 Loan Date 8 Rate 1/1 2011 9.2% 24 months 1/15/2011 9.2% 90 day Exact $8,000 1/15/2011 9.2% 120 Time 10 11 Interest 12 Maturity Value Due Date 15 Directions: 16 In Cell B11, enter a formula to compute the Simple Interest. 17 In Cell C11, enter a formula to calculate Ordinary Interest. 13 a. You want to borrow $8,000 for 24 months at a rate of 9.2%. b. You decide to change the length of pay-back time to 90 days C. Now you decide to change the length of time to 120 days. 18 In Cell D11, enter a formula to calculate Exact Interest. 19 d. In Cells B12 through D12, enter formulas to compute the Maturity Value 20 e. In Cell B13, enter the Due Date of 1/15/13 (1/15/11 plus 24 months). g Format dollar amounts for Currency, 2 Decimal places and S. 22 Format date entries for Date x/xx/xxxx ch10ex07.xlsx - +100% O Type here to search rP ^ 40 ENG 605 PM 3/15/2019 ch10ex07 [Modo de compatibilidad] - Excel Archivo inicio Insertar Diseo de pgina Frmulas Datos Revisar Vista Qu desea hacer? Empe Urbina Compartin | Chapter 10-Exercise 07 B. Calculate maturity value and date, discount date, days remaining 25 and bank discount and proceeds 26 27 Face Value 28 Rate 29 Time in Days 30 31 Date of Note 32 33 Days Before Discount 34 35 Discount Rate 36 $28,000 10% 120 Maturity Value 615/2011 Maturity Date Discount Date 15% Days Remaini Bank Discount Bank Proceeds 38 39 40 Directions 41 a. In Cell D30, enter a formula to calculate the Maturity Value 42 b. In Cell D32, enter a formula to compute the Maturity Date 43 C. In Cell D34, enter the formula to compute the Discount Date. 44 d. In Cell D36, enter a formula to calculate the Days Remaining 45 e. In Cell D37, enter a formula to compute the Bank Discount 46 f. In Cell D38, enter a formula to compute the Bank Proceeds. g. Format dollar amounts for Currency, 2 Decimal places, and $ 47 Format date entries for Datexxxxx. 48 h. Save the file as ch10ex07a.xlsx ch10ex07.xlsx - +100% O Type here to search ENG 606 PM 3/15/2019 ^