Question: ANSWER IN EXCEL I would like to purchase a vacation house in the mountains of Colorado, where we like to go periodically. We would need

ANSWER IN EXCEL

I would like to purchase a vacation house in the mountains of Colorado, where we like to go periodically. We would need to borrow approximately $395,000.00 make the deal. We can get a loan from a local Credit UnionIt would be a $395,000 loan, but we must pay a $2000 not refundable processing fee, and we must purchase stock in the amount of 1,500.00 which earns nothing (but we get it back at the end of the loan period) In addition, we would also incur a $2,500 not refundable appraisal fee (all of these would be withheld from the loan proceeds). The annual interest rate offered would be 4.35%, and we would make MONTHLY payments for years until the loan is paid off.

a. Calculate the Monthly payment on the $395,000 loan at 4.35% annual interest

b. What would be the period cash flow (loan proceeds the stock purchase the processing fee the appraisal fee).

If the house costs $415,000.00, how much would we have to come up with for the total out of pocket down payment ?

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!

Draw supply and demand graphs that estimate what will happen to demand, supply, and the equilibrium price of coffee if these events occur: a. Widely reported medical studies suggest that coffee...

I would like to purchase a vacation house in the mountains of Colorado, where we like to go periodically. We would need to borrow approximately $395,000.00 make the deal. We can...I would like to...

B 1. ANSWER IN EXCELI would like to purchase a vacation house in the mountains of Colorado, where we like to go periodically. We would need to borrow approximately $395,000.00 make the deal. We can...

I would like to purchase a vacation house in the mountains of Colorado, where we like to go periodically. We would need to borrow approximately $395,000.00 to make the deal. We can get a loan from a...

1. I would like to purchase a vacation house in the mountains of Colorado, where we like to go periodically. We would need to borrow approximately $350,000.00 to make the deal. We can get a loan from...

Basis below case , kindly answer ; Question to be Answered : What will be the best exit option for Nigel and Tammy if they decide to do so? Should We Stay or Should We Go? The Case of the Adventure...

Please answer this question.. Very easy. -What sources of value most plausibly account for the differences between buyer and seller? -Structure and execute a discounted cash flow valuation of all of...

I want answers to the case study below CASE STUDY The Rise, Fall, and Resurrection of Iridium: A Project Management Perspective The Iridium Project was designed to create a worldwide wireless...

The Rise, Fall, and Resurrection of Iridium: A Project Management Perspective The Iridium Project was designed to create a worldwide wireless handheld mobile phone system with the ability to...

please provide answers from 5 to 18 The Rise, Fall, and Resurrection of Iridium: A Project Management Perspective The Iridium Project was designed to create a worldwide wireless handheld mobile phone...

Question 1. Explain the terms in your own word Poor Quality Of Reported Earning i. Accounting for Acquisition ii. High Capital Expenditure iii. Revenue Recognition Issues iv. Weak Financial Control...

Two-lens systems In Figure stick figure O (the object) stands on the common central axis of two thin, symmetric lenses, which are mounted in the boxed regions. Lens 1 is mounted within the boxed...

A payoff table is given as S1 S2 S3 D1 10 8 6 D2 14 15 2 D3 7 8 9 For 5 points each, answer the following questions: a. What decision should be made by the optimistic decision maker? b. What decision...

7. Make the unrealistic assumption that production is costless for the monopolist in question 6. Given the data from the above demand schedule, what price will the monopolist charge, and how much...

Which of the following statements is NOT true about finite capacity scheduling ( FCS ) ? Multiple Choice FCS Is an extension of Gantt chart methods. In FCS , attention is paid to scarce resources to...

5. What are the other economic side effects of accidents?

2. What do you think of the safety program? What else would you suggest, and why?

7. What other steps would you suggest the company take to boost safety? For instance, what would you have supervisors do to improve the companys safety and accident record?