Question

In: Accounting

Problem 12. Show your work! (a) (5 marks) Cersei wants to set up a college fund...

Problem 12. Show your work!

(a) Cersei wants to set up a college fund for her son Tommen. Investments deposited at the Iron Bank of Braavos earn 8% interest per year, compounded quarterly. If Cersei invests $7000 with the Iron Bank of Braavos, how long will it take her investment to be worth $126 000?

(b) Cersei also take out a $212 000 mortgage to buy a home in King’s Landing, amortizing it over 30 years at 5.5%, compounded monthly.

(a) What are her monthly payments?

(b) What is the remaining principal after 18 years?

Solutions

Expert Solution

First:

Payments to achieve future value N= Log(FV/PV)/ Log(1+r)
Future value FV=                         126,000
Present value PV=                              7,000
Interest rate:
Stated rate 8.0%
/ number of compounding periods per year 1
Interest rate per period r= 8%
Periods to achieve future value N= Log( 126000/7000 )/ Log( 1+ 0.08 )
N= 37.56

Second

a

Monthly payment = [P × R × (1+R)^N ] / [(1+R)^N -1]
Using the formula:
Loan amount P $                                                          212,000
Rate of interest per period:
Annual rate of interest 5.500%
Frequency of payment = Once in 1 month period
Numer of payments in a year = 12/1 = 12
Rate of interest per period R 0.055 /12 = 0.4583%
Total number of payments:
Frequency of payment = Once in 1 month period
Number of years of loan repayment =                                                                  30.00
Total number of payments N 30 × 12 = 360
Period payment using the formula = [ 212000 × 0.00458 × (1+0.00458)^360] / [(1+0.00458 ^360 -1]
Monthly payment = $                                                         1,203.71

b

Loan balance = PV * (1+r)^n - P[(1+r)^n-1]/r
Loan amount PV = 212,000.00
Rate of interest r= 0.4583%
nth payment n= 216
Payment P= 1,203.71
Loan balance = 212000*(1+0.00458)^216 - 1203.71*[(1+0.00458)^216-1]/0.00458
Loan balance =                                                                         126,683.64

Related Solutions

Problem 12. (a) (5 marks) Cersei wants to set up a college fund for her son...
Problem 12. (a) Cersei wants to set up a college fund for her son Tommen. Investments deposited at the Iron Bank of Braavos earn 8% interest per year, compounded quarterly. If Cersei invests $7000 with the Iron Bank of Braavos, how long will it take her investment to be worth $126 000? (b) Cersei also take out a $212 000 mortgage to buy a home in King’s Landing, amortizing it over 30 years at 5.5%, compounded monthly. (a) What are...
For the Week 5 Problem Set, show all work in an Excel book, labeling each item...
For the Week 5 Problem Set, show all work in an Excel book, labeling each item by the problem number. Save the file in the format flastname_Unit_5_Learning_Activity.xlsx, where flastname is your first initial and your last name, and submit it to the appropriate Dropbox. For full credit, be sure to use appropriate formulas to solve each exercise or problem. Chapter 7 (page 149) 1. Calculate the present value (PV ) of a cash inflow of $500 in one year, and...
Samantha wants to set up a fund which will provide in perpetuity a scholarship of $2,600...
Samantha wants to set up a fund which will provide in perpetuity a scholarship of $2,600 to a deserving student at the end of each year with the first payment being made one year from today . Find the amount Betty should deposit today into the fund to provide for this scholarship if the interest rate is 3.8% compounded quarterly.
Betty Lovelace wants to set up a fund which will provide in perpetuity a scholarship of...
Betty Lovelace wants to set up a fund which will provide in perpetuity a scholarship of $2,600 to a deserving student at the end of each year with the first payment being made one year from today . Find the amount Betty should deposit today into the fund to provide for this scholarship if the interest rate is 3.8% compounded quarterly
Lionel wants to set up a fund for his son's education such that he could withdraw...
Lionel wants to set up a fund for his son's education such that he could withdraw $1,295.00 at the beginning of every 3 months for the next 6 years. If the fund can earn 3.30% compounded semi-annually, what amount could he deposit today to provide the payment?
You set up a college fund in which you pay $3500 each year at the beginning...
You set up a college fund in which you pay $3500 each year at the beginning of the year. How much money (in $) will you have accumulated in the fund after 29 years, if your fund earns 7% compounded annually?
(14 marks) Show your work for full marks: Forty-five percent of the applications received for a...
Show your work for full marks: Forty-five percent of the applications received for a particular credit card are accepted. Among the next ten applications,    A) What is the probability that all will be rejected? What is the probability that all will be accepted? What is the probability that exactly 4 will be accepted? What is the probability that fewer than 3 will be rejected? What is the probability that more than two will be rejected?(Use Excel to solve and write...
You set up a college fund in which you pay $5000 each year atthe beginning...
You set up a college fund in which you pay $5000 each year at the beginning of the year. How much money (in $) will you have accumulated in the fund after 24 years, if your fund earns 9% compounded annually?
You set up a college fund in which you pay $2500 each year atthe end...
You set up a college fund in which you pay $2500 each year at the end of the year. How much money will you have accumulated in the fund after 10 years, if your fund earns 8% compounded annually?
Unemployment (show all work) (10 Marks) Suppose that country a population of 120 made up of...
Unemployment (show all work) Suppose that country a population of 120 made up of a labour force of 100 and 20 children under the age of 15, What is the participation rate. Eight members of the labour force are unemployed What is the unemployment rate? Of the eight unemployed 2 worked in a factory that produced pies this factor has closed down and expected to open up after the pandemic. Describe what type of unemployment this is and why. One...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT