PARTC A couple purchases a new living room furniture set from Rooms-4-U at a price of $3,799. It is to be repaid in 15 monthly payments of $285 each. The first payment is due 30 days after the furniture purchase. What is the interest rate per month that Rooms-4-U is charging? What is the nominal annual interest rate Rooms-4-U is charging? What is the effective annual interest rate Rooms-4-U is charging? How much more did the couple end up paying for the furniture compared to the original purchase price? Sabiathe problemin EXCEL using an EXCEL spreadsheet function Make interest rate Rooms-4 up paying for the furniture compared to the orig Sove the problem in EXCEL using an EXCEL spreadsheet function. Make sure to fill in your columns with information and use the appropriate EXCEL function to give the final answer. PARTD Create a cash flow diagram in EXCEL as a stacked column chart to represent the situation above. Make sure to label chart title, point-of-view, interest rate per period time units receipts and disbursements, axis labels, and data labels as well as list any assumptions you might have it needed. ft Office PARTC A couple purchases a new living room furniture set from Rooms-4-U at a price of $3,799. It is to be repaid in 15 monthly payments of $285 each. The first payment is due 30 days after the furniture purchase. What is the interest rate per month that Rooms-4-U is charging? What is the nominal annual interest rate Rooms-4-U is charging? What is the effective annual interest rate Rooms-4-U is charging? How much more did the couple end up paying for the furniture compared to the original purchase price? Sabiathe problemin EXCEL using an EXCEL spreadsheet function Make interest rate Rooms-4 up paying for the furniture compared to the orig Sove the problem in EXCEL using an EXCEL spreadsheet function. Make sure to fill in your columns with information and use the appropriate EXCEL function to give the final answer. PARTD Create a cash flow diagram in EXCEL as a stacked column chart to represent the situation above. Make sure to label chart title, point-of-view, interest rate per period time units receipts and disbursements, axis labels, and data labels as well as list any assumptions you might have it needed. ft Office