Question: Show work through excel using formulas: but please actually show each step you use to do it on excel! 1. Let's assume that you have

Show work through excel using formulas: but please actually show each step you use to do it on excel!

1. Let's assume that you have just taken out a mortgage loan for $200,000 with an origination fee of 2 points due upfront. The mortgage term is 30 years and the mortgage rate is fixed at 4%. What is the cost of the origination fee in dollar terms?

A. $400.00 B. $954.83 C. $4000.00 D. $4954.83

2. Assume you have taken out a balloon mortgage loan for $2,500,000 to finance the purchase of a commercial property. The loan has a term of 5 years, but amortizes over 25 years. Calculate the balloon payment at maturity (Year 5) if the interest rate on this loan is 4.5%.

A. $5,637.99 B. $13, 895.82 C. $2,196,447.59 D. $2,495,479.19

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!

Show work through excel using formulas: but please actually show each step you use to do it on excel! 1. Assume you have taken out a balloon mortgage loan for $2,500,000 to finance the purchase of a...

**Please show work in excel with formulas as well as results** The ABC Corporation is considering opening an office in a new market area that would allow it to increase its annual sales by $2.5...

please show work in Excel and formulas Novak Landscaping began construction of a new plant on December 1,2022. On this date, the company purchased a parcel of land for $146,400 in cash. In addition,...

please show work and solve using formulas on paper. please do not show exel work Use a pricing-out strategy to check if either model would be economically attractive to make. The Strollers-to-Go...

Previous research states, "no evidence currently exists supporting or refuting the use of electric fans during heat waves" in terms of mortality and illness. Counterintuitively, Public Health...

Show work through excel formulas: please actually show how you do it on excel exactly! 1. Suppose you have taken out a $125,000 fully-amortizing fixed rate mortgage loan that has a term of 15 years...

This assignment has been created to show you how many of the topics in Chapter 3 are inter-related and how a business would use many of these concepts to help them make better decisions. Furthermore,...

please show work on Excel e 01 - Time Value of Money What is the present value of a five-year $25,000 ordinary annuity plus of a lump sum of $150,000 at the end of year 5. Discount rate of 11% Q2 -...

Please fill out the rest of the tables #4-5 for the calculations, USE the measurements given to solve for them. Answer Questions #1-12. Show work for all calculations step by step and use a clear...

The rate of flow in reservoir C is 150oli/sec. Elevation of of reservoir A is 10, that of B is 132m and that of C is 40m above sea level. The pump is located right after resevoir A on pipe 1. Length...

Required: For each of the following items indicate whether it increases, decreases, or has no effect (N/E) on cash flow: Cash flow Inc. Dec. N/E 1. Earning net income for the year 2. Redemption of...

Assume the following information: H . B . C . Bank J . P . Bank Bid price of Hong Kong dollar $ . 4 0 $ . 4 2 Ask price of Hong Kong dollar $ . 4 1 $ . 4 2 5 Given this information, is locational...

9. (15 points) A company is considering a new project that requires an investment of \$5 million. The project is expected to generate cash flows of $2 million in year 1,$3 million in year 2, and $4...

4. Describe the factors that influence self-disclosure

2. List one family relationship, one friendship, and one romantic relationship in which you are or have been involved. For each of these relationships, list at least five self-disclosures you made to...

1. Explain key aspects of interpersonal relationships