In: Finance
You and your spouse have decided that now is a good time to "buy vs. own." You have found a dream house that costs 278970 and you can get an loan-to-value of 89%. Your broker has lined up a traditional, fully amortizing loan at an interest rate of 6 annual, compounded 12/year for a 30 year term. What will your mortgage payments be if you buy the house?
You have taken on a new job that will be extremely intense and not leave much time for vacations. Your significant other is willing to put up with things but wants you to promise to take them on a dream vacation at the end of the 5th year. Since you haven't been able to deliver on these promises in the past, they want you to set aside enough money to cover that cruise which will cost $13835. If you can earn 5% annual, compounded monthly, how much will you have to set aside?
You are putting together a partnership and want to bring in a partner who is very focused on building up his wealth. You have run your cash flows and think you can promise to give him a constant annual dividend of 23109. Assume he can earn 6% compounded 1 times per year on his money. He wants to know what the investment will accumulate to if you run the partnership for 8 years. What will he have accumulated in his account by then?
You are worried about the future of social security and want to start saving. You think you can set aside $1606 per month. You have been offered an investment product on which you can earn 3% annually compounded 12 times per year. How much will this accumulate to if you plan to retire at the end of the 10th year?
a. | |||
Cost to House | 278,970.00 | ||
Part self finance | 30,686.70 | 278970*(1-89%) | |
Maximum Loan | 248,283.30 | 278970*89% | |
Interest Rate | 6% | ||
Compunded Monthly | 0.5% | 6%/12 | |
Duration(year) | 30 | ||
Period | 360 | 30*12 | |
Monthly Mortgage Payment= | |||
=(248283.3*.5%*(1+.5%)^360)/((1+.5%)^360-1) | 1,488.58 | ||
Monthly mortgage payment=1,488.58 | |||
b. | |||
Annual Interest | 5% | ||
Compunded Monthly | 0.416667% | 5%/12 | |
Duration(Year) | 5 | ||
Period | 60 | 5*12 | |
Future Value | 13,835.00 | ||
So we have calculate=13835/(PVIFA,.416667%,60) | |||
To calculate PVIFA, following is formula | |||
PVIFA=((1-(1+r)^(-n))/r) where r is Monthly interest, n = period | |||
=((1-(1+.416667%)^(-60))/.416667%) | 52.99 | ||
Divide 13835 by 52.99=13835/52.99 | 261.09 | ||
c | |||
Annual Dividend(P) | 23,109.00 | ||
Annual Compound( R) | 6% | ||
Period(Years)(N) | 8.00 | ||
Future Value | ? | ||
Formula for calculation of Future value of the annuity | |||
FV =( P *( {(((1+R)^N) - 1) / R}) | |||
FV=23109*(((((1+6%)^(8))-1)/6%)) | 228,720.59 | ||
d | |||
Monthly Saving (P) | 1,606.00 | ||
Annual Interest | 3% | ||
Compunded Monthly( R) | 0.25% | 3%/12 | |
Duration(Year) | 10 | ||
Period (N) | 120 | 10*12 | |
Future Value | ? | ||
Formula for calculation of Future value of the annuity | |||
FV =( P *( {(((1+R)^N) - 1) / R}) | |||
FV=1606*(((((1+.25%)^(120))-1)/.25%)) | 224,424.72 |