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

label Mathematics
account_circle Unassigned
schedule 1 Day
account_balance_wallet $5

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

Oct 22nd, 2017

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
...
Oct 22nd, 2017
...
Oct 22nd, 2017
Oct 22nd, 2017
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