Question
Please use the correct excel functions for the below questions. 1) Assuming an annual interest rate of 3%, what is the current value of the
Please use the correct excel functions for the below questions.
1) Assuming an annual interest rate of 3%, what is the current value of the following payment schedule?
$200,000 July 15, 2016 $130,000 April 15, 2017
$400,000 November 10, 2017
$200,000 February 14, 2018
2) Consider and solve for the following scenarios: Scenario 1: An insurance salesperson is attempting to sell you a policy that you need to contribute on a monthly basis, $150, for 10 years. The policy will pay a guaranteed 5% annual interest rate. That is, at the end of the payment stream you will get your $150/month * number of periods paid + interest. Scenario 2: You cant afford the $150 a month, and tell the salesperson, you will pay $75 and month and require a guaranteed annual interest rate of 8%. You will make a similar calculation to determine the value at the end of the payment stream, starting with monthly payments over 10 years, to determine the value. You find in your analysis that at the end of 10 years you will not get the same return on investment from Scenario 2 as you will with Scenario 1. How many monthly payments will you need to make in Scenario #2, to approximately match +/- $50 the value, and the end of the Scenario #1 payment stream?
3) Assume payments on a business loan are paid every quarter. The annual interest rate is 3.5%. What is the quarterly payment on a 10 year loan of $100,000?
Step by Step Solution
There are 3 Steps involved in it
Step: 1
![blur-text-image](https://dsd5zvtm8ll6.cloudfront.net/includes/images/document_product_info/blur-text-image.webp)
Get Instant Access with AI-Powered Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
![blur-text-image](https://dsd5zvtm8ll6.cloudfront.net/includes/images/document_product_info/blur-subtext-image.webp)
Step: 3
![blur-text-image](https://dsd5zvtm8ll6.cloudfront.net/includes/images/document_product_info/blur-subtext-image.webp)
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started