Question: I am doing something incorrectly, i need help trying to figure out what im doing wrong. the values in yellow are fixed. everything else is

I am doing something incorrectly, i need help trying to figure out what im doing wrong. the values in yellow are fixed. everything else is myself.

Enter Probable Monthly Gross Income Percent of Gross Income Allowed for Mortgage Calculate Mortgage Payment based on Max % Assumed down payment Mortgage Rate Frequency of Mortgage Length of Mortgage 11,000 Enter a # that seems right for you. 42% 4620 Multiply C3 x C2 20% 3.50% Monthly 30.00 max total loan amount able to pay in 30 years 1663200 Question 1: Calculate how much you can afford to borrow 20% down = 332640 PMT I/Y IN FV PV 4620 0.002917 360.00 1663200 ($1,611,757.46) Question 2: Calculate the amount of the down payment based on the max you can borrow. Loan Amount Total Home Value Down Payment $1,611,757.46 -$2,014,696.82 -402939.3646

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!

This journal should reflect upon what we learned in chapter 5 below, on Immanuel Kant in the Sandel book. As you write your journal in the direction that you like, please follow the following...

This text was adapted by The Saylor Foundation under a Creative Commons Attribution-NonCommercial-ShareAlike 3.0 License without attribution as requested by the work's original creator or licensee. 1...

Criteria Exemplary 6 points Accomplishe d 4.8 points Developing 3.6 points Beginning Minimum Below Standards 2.4 points 1.2 points Formulated, wrote, interpreted, argued, and evaluated...

LaDonna Powell My first day in the field was not great. I was put with this guy. He was an older white guy. And he was very nice to me but very mean to the people we were screening going onto the...

Planning and Control A) Provide brief definitions of the terms planning and control b) Describe the relationship (or link) between the planning and control functions; describe in detail this...

There are four management functions: Culture, Planning, Strategy, and Control. For each of the four management functions. Provide one specific example from the UPS case and explain how it relates to...

i just need to complete the excel Frenchies Signature Assignment Joseph Preimesberger posted on Nov 8, 2021 9:35 AM Edited This is a shortened assignment, so just complete the three Excel tabs given...

1) Read the "Cybersecurity: the three-headed Janus" case posted under Module 2. Provide a summary of the vulnerabilities of Randcom's current information systems. Make sure to address each...

pleas I need some help with this case study Henri Boulangerie: Creating and Using a Master Budget BACKGROUND PART I: CREATING THE BUDGET MEETINGS WITH DIVISIONAL MANAGERS Henri Boulangerie is a...

THIS IS FOR POLICE PREPARATION CLASS: THIS IS A PRESENTATION TRANSCRIPT: They kind of led me in the direction of We Are public helpers it's what time someone told me so just being able and showing...

Consider each of the following highly reactive carbon species. What is the formal charge on carbon in each of these structures? H-C-H

Describe Costco Whole's social responsibility program or policy- if they have one. Does Costco Wholesale's performance and behaviors support their mission statement? Describe any significant current...

Problem 1 8 - 6 ( Algo ) Statement of shareholders' equity; financial statement effects [ LO 1 8 - 1 , 1 8 - 3 , 1 8 - 4 , 1 8 - 5 , 1 8 - 6 , 1 8 - 7 , 1 8 - 8 ] Comparative statements of...

Skills necessary for success in marketing include Multiple select question. analytical thinking advertising industry experience infallibility ability to work with others

What is a constructive discharge? Provide an example of a constructive discharge.

Why should some form of seniority be used as a criterion in identifying employees for layoff?

Why is it necessary to pay particular attention to the employees that are retained following a reduction-in-force? What is the basis for concern, recognizing that these survivors still have their...