Question

In: Finance

1) Lucy wants to buy a house. The house costs $825,000. She will make a 20%...

1) Lucy wants to buy a house. The house costs $825,000. She will make a 20% down payment. She will have a 30-year mortgage at an interest rate of 5%.

a) Make an amortization schedule for the first 6 payments (not years) of her loan. Make sure your amortization table has the following columns (in this order): beginning balance, payment, interest, principal reduction, and ending balance. (Make sure you round to the nearest cent, not dollar!)

b) Assuming she follows her amortization schedule, what will be the total interest she will pay for her home after 30 years? Show calculations.

2) Lucy wants to retire comfortably. She wants to have 10 million dollars by the time she retires in 30 years.

a. How much money does Lucy need in her account today in order to have 10 million dollars in 30 years? She can earn 6% interest, compounded annually.

b. If Lucy were to make year-end payments to her account for the next 30 years, what would her payment amount have to be in order to have the 10 million dollars in 30 years, @ 6% interest, compounded annually?

3) Mary makes $16,000 a month (gross). She is married and claims 5 exemptions. Her state income tax withholding is 5%. (Use the text’s limit for social security, for parts a-c.)

a. What is Mary’s net pay for January? (After ALL taxes and withholdings…don’t forget SS, Med., FIT…) Show each tax/withholding amount (list Gross, then list each tax subtracted out to get net pay).

b. What is Mary’s net pay for September? (Not cumulative, JUST September’s net pay.)

c. What are Mary’s total taxes paid/withheld for the year? (Specify amounts for each tax.)

d. What is the current year’s income limit (base) for social security and maximum social security tax payable (in dollar amount)?

4) Pick two companies and track their stocks for three trading days (not weekends or holidays). You can find their stock information on the internet or in a newspaper. Tell me: the company’s name, their symbol, what stock market they are trading on, their high and low for the past year, what their dividend per share was last year, their closing price each day and what their price earnings ratio was for those days (show the calculation).

5) Find the consolidated financial statements for Garmin Ltd and Subsidiaries for the year ended December 29, 2018 and compute the following ratios: current ratio, debt to assets ratio, and return on equity ratio. (Form 10-K, search online). Show your calculations to earn credit. What might these ratio’s show about this company?

6) Pick two “Personal Finance, A Kiplinger Approach” or My Money articles from the textbook. (They are at the end of each chapter.) For each article you pick, write a one to two paragraph summary of the article and another paragraph on your thoughts/opinion/insights and items learned from reading the article. Indicate page number and which chapter the article is from.

Solutions

Expert Solution

1.a

loan value = house cost -down payment = $825000- $825000*0.2 = $825000-$165000 = $660000

monthly rate = 0.05/12 = 0.0041667

Monthly payment (PMT) = =-PMT(rate,nper,pv,fv,type)

=-pmt(0.0041667,360,0,0)

= $3543.02

nper = 30year *12 = 360 month.

interest = beginning balance * 0.0041667

principle = monthly payment - interest

ending balance = beginning balance - principle

next month beg bal = last month ending bal.

1b

Total payment after 30year =monthly payment * total month = $3543.02 *360 = $1275480

loan value = $660000

Total interest payment after 30 year = Total payment - loan value = $1275480- $660000 = $615480

hence you will pay $615480 as interest in next 30 years.


Related Solutions

Becky Sayers wants to buy a house in five years. She hopes to be able to make a down payment of $25,000 at that time
Becky Sayers wants to buy a house in five years. She hopes to be able to make a down payment of $25,000 at that time. If the bank CD she wants to invest in will pay 5.5 percent annually, how much will she have to invest today?
Jane plans to buy a house in 10 years. The house she dreams about costs about...
Jane plans to buy a house in 10 years. The house she dreams about costs about $150,000 today. The cost of houses increases at 2.5% per year. Jane will accumulate $100793.72 from her investment of 75,000 in 10 years. In addition, Jane needs to borrow $91218.96 additional money to purchase her house in 10 years. a) Prepare an amortization table to pay off Jane’s mortgage, if she can borrow at an annual rate of 6.5% to pay off the mortgage...
Jane plans to buy a house in 10 years. The house she dreams about costs about...
Jane plans to buy a house in 10 years. The house she dreams about costs about $150,000 today. The cost of houses increases at 2.5% per year. Jane will accumulate $100793.72 from her investment of 75,000 in 10 years. In addition, Jane needs to borrow $91218.96 additional money to purchase her house in 10 years. a) Prepare an amortization table to pay off Jane’s mortgage, if she can borrow at an annual rate of 6.5% to pay off the mortgage...
Eowyn wants to buy a house that is priced at $235,000. She makes a down payment...
Eowyn wants to buy a house that is priced at $235,000. She makes a down payment of 20% and then finances the balance with a loan that will require her to make monthly payments for thirty years, with the first payment due one month after the purchase of the house. If her lender charges 4.25% per year compounded monthly, find the outstanding loan balance after she makes 7 years of payments.
Adrian wants to buy a house for $206,700. He is planning on making a 20% down...
Adrian wants to buy a house for $206,700. He is planning on making a 20% down payment, and closing costs will amount to $3,180. Annual property taxes are $4,890, and homeowners insurance is $816 per year. How much money will he need up front?
"Ms. Jones wants to buy a new car for $30,000. She will make a down payment...
"Ms. Jones wants to buy a new car for $30,000. She will make a down payment of $15,000. She would like to borrow the remainder from a bank at an interest rate of 9.6% compounded monthly. She agrees to pay off the loan monthly for a period of 3.25 years. Assume that Ms. Jones has made 16 payments and wants to figure out the balance remaining immediately after the 16th payment. Determine the remaining balance." Show all work
Suppose that you decided to buy a new house. The house you want to buy costs...
Suppose that you decided to buy a new house. The house you want to buy costs $520,000 and the interest rate is 7%. You currently have $130,000 and are required to put a 20% down payment plus an additional 3% of the loan amount as closing costs. 1) When will you have enough money for the down payment and closing costs, assuming that the $80,000 is the only investment that you make? 2) Suppose that you plan to buy the...
Esmerelda buys a house for $450000. She makes a 20% downpayment on the house and for...
Esmerelda buys a house for $450000. She makes a 20% downpayment on the house and for the remaining balance takes out a 30-year mortgage at 4.25% annual interest compounded monthly. a. What are her monthly payments? (1 point) dollars Show your work: (12 points) b. 20 years into the mortgage, she inherits enough money to pay off the remaining balance. How much is the remaining balance? (1 point) dollars Show your work: (3 points)
(1 point) Suzie wants to buy a car for $6750. If she pays cash she receives...
(1 point) Suzie wants to buy a car for $6750. If she pays cash she receives a 8.5% cash discount. To get the cash she signs a 120-day non-interest bearing note. If the bank discounts notes at an interest rate of 6% what face value is needed on the note for Suzie to receive the cash she needs to buy the car?
You purchase a house that costs $625,000 with an 8%, 30-year mortgage. You make a 20%...
You purchase a house that costs $625,000 with an 8%, 30-year mortgage. You make a 20% down payment to avoid PMI insurance. 1. What is your monthly payment? 2. Amortize the first and second payments. 3. What is the mortgage balance after 5 years? 4. What percentage of the principal is paid off after 5 years? 5. Suppose after 5 years you refinance at 6% the remaining balance at a cost of $10,000, for 30 years. What is your new...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT