What are the bank proceeds from the $35,000 loan?
Round your answer to two decimal places. $
What are the bank proceeds from the $47,000 loan?
Round your answer to two decimal places. $
ch10ex03 [Modo de compatibilidad] - Excel Archivo inicio Insertar Diseo de pgina Frmulas Datos Revisar Vista Qu desea hacer? Empe Urbina Compartin A1 | Chapter 10-Exercise 03 Chapter 10-Exercise 03 3 Face Value 4 Rate 5 Time Da $35,000 9.5% 90 Maturity Value 7 Date of Note 6/15/2011 60 15% Maturity Date 9 Days Before Discount 10 11 Discount Rate 12 13 Discount Date Days Remainin Bank Discount Bank Proceeds 15 6 Directions: a. In Cell D6, enter the formula to calculate the Maturity Value Face Value times the result of 1 plus Rate times Time divided by 360). (Date of Note plus Time). (Date of Note plus Days Before Discount) (Time minus Days Before Discount) 17 b. In Cell D8, enter the formula to compute the Maturity Date c. In Cell D10, enter the formula to compute the Discount Date d. In Cell D12, enter the formula to calculate the Days Remaining e. In Cell D13, enter the formula to compute the Bank Discount 18 19 20 ch10ex03.xlsx - +100% O Type here to search RENG 6-15 PM 3152019 ch10ex03 [Modo de compatibilidad] - Excel Archivo inicio Insertar Diseo de pgina Frmulas Datos Revisar Vista Qu desea hacer? Empe Urbina Compartin A1 | Chapter 10-Exercise 03 9 Days Before Discount 10 11 Discount Rate 12 13 14 15 6 Directions: 60 Discount Date 15% Days Remainin Bank Discount Bank Proceeds a. In Cell D6, enter the formula to calculate the Maturity Value (Face Value times the result of 1 plus Rate times Time divided by 360). b. In Cell D8, enter the formula to compute the Maturity Date 17 (Date of Note plus Time). c. In Cell D10, enter the formula to compute the Discount Date 18 (Date of Note plus Days Before Discount) d. In Cell D12, enter the formula to calculate the Days Remaining 19 (Time minus Days Before Discount) e- In Cell D 13, enter the formula to compute the Bank Discount 20 (Maturity Value times Discount Rate times Days Remaining f. In Cell D14, enter the formula to compute the Bank Proceeds g. Format dollar amounts for Currency, 2 Decimal places, and $. 21 divided by 360) 22 (Maturity Value minus Bank Discount) 23 Format date entries for Date x/xx/xxxx 24 h. Save the file as ch10ex03a.xisx 25 ch10ex03.xlsx +100% 6-16 PM O Type here to search RENG 3152019 ch10ox04 [Modo de compatibilidad] - Excel Archivo inicio Insertar Diseo de pgina Frmulas Datos Revisar Vista Qu desea hacer? Empe Urbina Compartin A1 | Chapter 10-Exercise 04 Chapter 10-Exercise 04 3 Face Value 4 Rate 5 Time Da $47,000 7% 60 Maturity Value 5/20/2011 45 13% 7 Date of Note Maturity Date 9 Days Before Discount 10 11 Discount Rate 12 13 Discount Date Days Remainin Bank Discount Bank Proceeds 15 6 Directions: 17 a. In Cell D6, enter a formula to calculate the Maturity Value 18 b. In Cell D8, enter a formula to compute the Maturity Date 19 C. In Cell D10, enter a formula to compute the Discount Date 20 d. In Cell D12, enter a formula to calculate the Days Remaining 21 e. In Cell D13, enter a formula to compute the Bank Discount 22 f. In Cell D14, enter a formula to compute the Bank Proceeds g. Format dollar amounts for Currency, 2 Decimal places, and $. 23 Format date entries for Date xxx/xxxx 24 h. Save the file as ch10ex04a.xisx 25 ch10ex04.xlsx - +100% 6-18 PM O Type here to search RENG 3152019
