Question: please show all work through excel spaced out for 5-8 5- Suppose you borrowed S45,000 to purchase a new car. The leader charges 4.5% annually

please show all work through excel spaced out for 5-8

5- Suppose you borrowed S45,000 to purchase a new car. The leader charges 4.5% annually and the loan is for 5 years. What is the monthly payment? 6- You sign up for a 401k plan at work and contribute $1,000 each month beginning today. What is account's value on 2/18/2071 if you earn 7% per year and make the last contribution on 1/18/2071? 7. You win the lottery and a $1,000,000 prize. The prize pays monthly installments for 10 years and you discount them at 8%. What is the present value of the prize? 8. You just signed a 39 month lease on a 2021 BMW X-7. The car costs $70,000 and has a residual value of $40,000. If the lease carries a 5% interest rate, what are the monthly payments

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related Finance Questions!

please show all work for questions through excel spaced out 5- Suppose you borrowed S45,000 to purchase a new car. The leader charges 4.5% annually and the loan is for 5 years. What is the monthly...

please show all work of answers spaced out through excel Calculate: 8 points each 1- The present value of $10,000 to be received on 2/18/31 with a 9% d.f. 2- The future value on 2/18/55 of $30,000...

please show all work spaced out through excel 5- Suppose you borrowed S45,000 to purchase a new car. The leader charges 4.5% annually and the loan is for 5 years. What is the monthly payment? 6- You...

please show all work neat and spaced out Calculate: 8 points each 1- The present value of $10,000 to be received on 2/18/31 with a 9% d.f. 2- The future value on 2/18/55 of $30,000 earning 6% per...

please show all work for questions Calculate: 8 points each 1- The present value of $10,000 to be received on 2/18/31 with a 9% d.f. 2- The future value on 2/18/55 of $30,000 earning 6% per year...

Please help with these Capsim Production numbers. I believe 6-15 is good how it currently is. 1-5 I am not sure how to get the production schedule numbers, please show your work. Eat=Traditonal,...

I need help with question three from the file. I'm not sure how to calculate the net revenue. UNIVERSITY OF ILLINOIS AT CHICAGO HIM 481 - HEALTHCARE FINANCIAL MANAGEMENT Project 1: Building a...

Assuming Juan provided an average of 45 free hot dogs per month to needy families, and adding the discount given to members of the police force, what is the total contractual and charity allowances...

Based off of my calculations can you create an income statement, balance sheet and cash flow statement? Project 1: Building a Financial Statement Instructions: Read through the scenario and complete...

PowerPoint Assignment for BUS 401: Principles of Finance You have been asked by a manager in your organization to put together a training program explaining Net Present Value (NPV) and Future Value...

() 2. A range finder is shown by the following picture? The elapsed time of its wave is 100 ms. What's the distance from station A to station B? (Suppose the speed of wave propagation is 340 m/s) B...

Refer to the information in E3-36. Denis operated Deniss Great Gifts until December 31. In the two months, he sold merchandise to customers for $52,000, all in cash, except for $1,200 that was owed...

Which of the following is considered debt and/or a debt equivalent? Select ALLthat apply. Noncontrolling interest An investment in a debt security Commercial paper Operating leases

Add "Viggo Mortenslet cast = new Map ( ) ;en " to the cast as the key, with value "Aragorn".