the bank approves her car loan request at annual rate of 9%, how much should she pay weekly to make sure she brings the balance of her loan to zero in 6 years. Does it make any difference if she pays the weekly loan payments at the beginning or end of the week? If yes, caliculate the difference for the whole loan period. 38 Noella is considering multiple loan options with varying interest rates for her car purchase at $30,000. She wants to build a dynamic table to systematically compare a range of weekly interest rates and the impact of different cash down options simultaneously. Remember that she has $2,500 available as cash down but she is not sure how much of it to use. Thinking of a six year long loan period, help her decide on the weekly payment by building such a table using the following input ranges: a) Weekly interest rate changes between 1% and 5% with half percent increments; b) cash down changes from $500 to $2,500.00 with increments of $250. Which option would you select and recommend? Justify your logic and use a new worksheet to answer, 39. Based on the highest sales commission amount, advise the corresponding sales employee on the interest rate s/he must ask for by investing all his/her compensation over the next 5 years making equal payments annually. Note that, hypothetically, the commission amount does not vary year over year, So the employee can keep investing year after year. The goal is to help this individual grow his/her investment into $50,000.00. Based on the going interest rate of the Canadian market, do you think this goal is realistic? 40 Suppose Noella needs CANS 10,000.00 to buy a jet ski, and finally have a blast during summer of 2024 . The going monthly interest rates is half a percent. How much money should she put aside now from her commission (Fal of 2022) in order to pay for the purchase in Fall of 2024 . Do you think she can actually do the purchase based on her actual commistion? the bank approves her car loan request at annual rate of 9%, how much should she pay weekly to make sure she brings the balance of her loan to zero in 6 years. Does it make any difference if she pays the weekly loan payments at the beginning or end of the week? If yes, caliculate the difference for the whole loan period. 38 Noella is considering multiple loan options with varying interest rates for her car purchase at $30,000. She wants to build a dynamic table to systematically compare a range of weekly interest rates and the impact of different cash down options simultaneously. Remember that she has $2,500 available as cash down but she is not sure how much of it to use. Thinking of a six year long loan period, help her decide on the weekly payment by building such a table using the following input ranges: a) Weekly interest rate changes between 1% and 5% with half percent increments; b) cash down changes from $500 to $2,500.00 with increments of $250. Which option would you select and recommend? Justify your logic and use a new worksheet to answer, 39. Based on the highest sales commission amount, advise the corresponding sales employee on the interest rate s/he must ask for by investing all his/her compensation over the next 5 years making equal payments annually. Note that, hypothetically, the commission amount does not vary year over year, So the employee can keep investing year after year. The goal is to help this individual grow his/her investment into $50,000.00. Based on the going interest rate of the Canadian market, do you think this goal is realistic? 40 Suppose Noella needs CANS 10,000.00 to buy a jet ski, and finally have a blast during summer of 2024 . The going monthly interest rates is half a percent. How much money should she put aside now from her commission (Fal of 2022) in order to pay for the purchase in Fall of 2024 . Do you think she can actually do the purchase based on her actual commistion