Martin and Samantha need your help again to determine the best course of action for their company Please read the following scenario, complete the tasks below, and create a report for Martin and Sam to provide to their company Martin and Samantha, along with the other executive managers, have decided to open anether effice in ourTown City They are looking to infuse cash into in a long term investment and have decided to purchase a home in the city to use for office space. They understand that al investments carry some level of jsk but long-term investments have larger risk because they are over longer the period of time. Help them to determine the best strategy for making this company investment. You will need to apply the concepts of time value of money to evaluate their options. They plan to take out a mortgage and put down $20,000 for a down payment. Tasks 1. Identify the purchase price of a house that they might want to buy in a residential neighborhood in your town. 2. Watch this video on how to use Microsoft Excel to compute the mortgage payment. 3. Download and use this Microsoft Excel template to compute: 15 Year Mortgage-The payment on a 15-year mortgage at 4.75% fixed rate loan 30 Year Mortgage . The payment on a 30-year mortgage at 4.75% fixed rate loan The Total amount repaid to the bank. 4. Please create a report for Martin and Samantha in a Microsoft Word document to address the questions below. Use a minimum of one additional, credible, source to support your findings. Cite your sources and format your paper using the APA style guide. (You are not required to write an abstract.) Your report should be a minimum of one page, not including the cover and reference pages. Be sure to address the relevant topics in this unit. What was the amount financed? Which mortgage was the best choice? Why? Which mortgage charged the most interest over the life of the loan? Why? What strategies could you use to lower the amount of interest paid? Martin and Samantha need your help again to determine the best course of action for their company Please read the following scenario, complete the tasks below, and create a report for Martin and Sam to provide to their company Martin and Samantha, along with the other executive managers, have decided to open anether effice in ourTown City They are looking to infuse cash into in a long term investment and have decided to purchase a home in the city to use for office space. They understand that al investments carry some level of jsk but long-term investments have larger risk because they are over longer the period of time. Help them to determine the best strategy for making this company investment. You will need to apply the concepts of time value of money to evaluate their options. They plan to take out a mortgage and put down $20,000 for a down payment. Tasks 1. Identify the purchase price of a house that they might want to buy in a residential neighborhood in your town. 2. Watch this video on how to use Microsoft Excel to compute the mortgage payment. 3. Download and use this Microsoft Excel template to compute: 15 Year Mortgage-The payment on a 15-year mortgage at 4.75% fixed rate loan 30 Year Mortgage . The payment on a 30-year mortgage at 4.75% fixed rate loan The Total amount repaid to the bank. 4. Please create a report for Martin and Samantha in a Microsoft Word document to address the questions below. Use a minimum of one additional, credible, source to support your findings. Cite your sources and format your paper using the APA style guide. (You are not required to write an abstract.) Your report should be a minimum of one page, not including the cover and reference pages. Be sure to address the relevant topics in this unit. What was the amount financed? Which mortgage was the best choice? Why? Which mortgage charged the most interest over the life of the loan? Why? What strategies could you use to lower the amount of interest paid