Time remaining:
how do i set up equations on excel based upon my financial project?

Mathematics
Tutor: None Selected Time limit: 1 Day

the question states current 30 year mortgage rates are 4.25% we are to not spend more than 28% of our gross income on house payments. we have 28,000 as high school graduate and i have $38,520 from my dream job we have to find out how much we should pay and compare each salary

Apr 25th, 2015

For this problem, you can use the NPV function. The term is 30 years, the rate is 4.25%, and the gross income varies. The percentage available for rent, however, changes. Using the NPV formula with these values gives you the dollar amount that you can take out a mortgage for. Attached is the excel sheet showing the formulas as illustration. 


equation.xlsx 

Apr 25th, 2015

Studypool's Notebank makes it easy to buy and sell old notes, study guides, reviews, etc.
Click to visit
The Notebank
...
Apr 25th, 2015
...
Apr 25th, 2015
Dec 11th, 2016
check_circle
Mark as Final Answer
check_circle
Unmark as Final Answer
check_circle
Final Answer

Secure Information

Content will be erased after question is completed.

check_circle
Final Answer