Question: PLEASE SHOW ME THE EXCEL FUNCTION aND HOW TO DO IT FOR THIS NEXT PART PLEASE and how to do thE function short cut so

PLEASE SHOW ME THE EXCEL FUNCTION aND HOW TO DO IT FOR THIS NEXT PART PLEASE and how to do thE function short cut so i dont have to write all the cash flow tables

-

Now presume that in addition to the points at origination the seller also has to pay one point in pre

-

payment penalty at the time the loan is paid off.

What is the yield?

Yield

= 8.66 %

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!

Patterson, Inc. has provided details of its actual cost data for the month. The Controller has asked you to compute the basic variances and the impact of those variances on unit costs. Use the...

Use in excel solver using the simplex LP features with excel for part of the problem. Please show screenshots of the formulas and excel workbook! This will help a ton. Part of the problem is also a...

Please show calculations in Excel. Otherwise, do not attempt to answer A protective collar involves buying an out-of-the-money put and writing an out-of-the-money call on an underlying asset that you...

The 40-strike put has a premium of $2.00. You find that a call with a strike of $41.72 also has a premium of $2.00 Both options will expire in in 6 months. Please write down the profit formula for...

I only need part C Answered use the data from part A part A Data: I only need part C of the question answered Using the data from part a. PLEASE Show work in EXCEL. thank You is $920. Utilities...

Please answer all questions for all parts. Please show your work for all answers. These questions are about Exponential Functions. Part 1: 1. Explain how you can write the sixth root of a number a)...

Please show work in excel, thank you! This is for an optimization and modeling class and I don't understand Tazer management now has concluded that the company cannot devote enough money to research...

Bauer Industries is considering purchasing a new machine, the XD-750, which would allow it to expand its production capacity. The cost of the XD-750 is $2.75 million. Unfortunately, installing this...

so, I have question only on 2-"f" not else, so please help me understanding the questions... i am just need a help to understand the what question is meaning :( rest of what i need in in very bottom...

5) Let V be the vector space of all 2X2 real matrices. 0 0(0 Show that the sets S = and (1 1)(1 S=- spans V.

Name and describe at least five methods of recruiting.

MC.08-046 MC.08-050 MC.08-051 MC.08-052 MC.08-053 MC.08-054 MC.08-055 MC.08-060 MC.08-061 MC.08-063 MC.08-074 MC.08-075 MC.08-076 MC.08-077 MC.08-078 MC.08-079 MC.08-080 MC.08-081 MC.08-082...

Your international Portfolio management team leader is confident that for the investor's required return estimation of a two stock portfolio, the most appropriate model is Fama French 3 factor model....