Question: Hello, I need help on finding the function to get me going on this exercise..I've submitted what I have so far. Do I continue to

Hello, I need help on finding the function to get me going on this exercise..I've submitted what I have so far. Do I continue to use the PMT fx on question 3? Thanks!

Search Currency $ File Home Insert Page Layout Formulas Data Review View Help PDF X Cut Arial 10 AA === Wrap Text L6 Copy Paste Format Painter BIUD A 3 Merge & Center - Clipboard Font Alignment a H8 : x fox --PMT($C$8/12,08,68) 4 A / B C D E F G H I J Loan Analysis Worksheet % Number 8-98 El l K L $500,000 3 Purchase Price # Number of Compounding Periods/year 5 Optional Balloon Payment $ 20,000 Actual Amount Borrowed APR Payment with Balloon Nominal Down Interest Duration 7 Option# Payment Ratelyr yrs) 20% 4.90% 30 10% 5.25% 30 5.75% 30 0% 6.25% 20% 5.50% 6.00% 6.50% Loan Value 400,000 450,000 475,000 500,000 400,000 450,000 475,000 Points Fees 3 375 3 375 3 375 3 0 11 0 0 350 0 350 Monthly Payment $14,193.84 $15,968.07 $16,855.18 $17,742.30 $14,193.84 $30,989.32 $32,710.95 30 AN- 10% 5% 7 Private loan (1) annual rate: 8 Private loan (2) duration: 9 CD value enough for 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!

look into the transcription of the videos that we coded for the Dominance project and identify if there are any errors (grammar and spelling and etc): 1673015005057.mp4 Baseline 181 Baseline181 Hi,...

I am having issues with this entire problem. I posted the problems. Can you please break down the formulas and points you use please To get the dialog box, click on fx, then Financial, then FV, then...

File Home Insert Page Layout Formulas Data Review View Help Tell me PROTECTED VIEW Be careful-files from the Internet can contain viruses. Unless you need to edit, it's safer to stay in Prote H A1 -...

123please help me with this Winter 1, 2013 7/22/2012 Chapter 4. Ch 04 P35 Build a Model Except for charts and answers that must be written, only Excel formulas that use cell references or functions...

Read the case scenario and use the text provided to support your answer and only used the text provided Case Scenario Dion is an engineer with Tesla Motors who helps to design electric motors. It has...

Need help with the following excel simulation assignment: a. Find the FV of $1,000 invested to earn 10% annually 5 years from now. Answer this question by using a math formula and also by using the...

Week 1 Lecture 1 Class Approach to Statistics Statistics is basically a set of tools that allow us to get information out of data sets (we will get to the more formal definition below). As such, it...

I need help answering part 2 of question K on the attached. the Goal Seek Question. if you could please aslo complete the question so I have an example I also need a little step by step to see how it...

This is a individual assignment, which is due on 27th of jan, wed, 1pm. Can u help me to do it? Financial Accounting 2 ACG 27, Study Period 4, 2015 Case Study for Annual Report Assignment The...

"Unions make it difficult for government to reduce the rate of unemployment." Discuss the logic underscoring this view and show how it relates to the Phillips curve.

Corporation A issues a $100,000, six-year convertible bond at 104 on January 1, 19B. This bond is convertible into 1,000 shares of $100 par common stock. Three years later, when the market value of...

An investment policy statement is created to: Outline the general rules for the advisor. List the client s objectives and constraints. List constraints for investment selections. Ensure that the risk...

A company is preparing completing their Cash Budget. The following data has been prepared for cash receipts and payments. January February March Cash receipts $1,061,200 $1,182,400 $1,091,700 Cash...