What is the amount of your weekly payment

Assignment Help Finance Basics
Reference no: EM131297002

PERSONAL FINANCIAL PLANNING ASSIGNMENT -

1. You are planning to buy a 4-bedroom house in Oshawa that has a price of $600,000. One of the local banks has offered you a mortgage at a quoted rate 8.00% per year. Interest will be compounded semi-annually. The bank has indicated that they will require a down payment of $200,000. The bank is prepared to lend you the remainder of the purchase price of the house. The amortization period will be 20 years and the term of the mortgage will be 2 years. You are going to make weekly payments on your mortgage. The payments will be made at the end of each week. Therefore you will make 52 payments per year. You have heard from your friend who has just completed the Introduction to Finance course, that by making additional payments on your mortgage during the initial term of the mortgage you can reduce the total number of payments and consequently the total amount of interest you pay over the entire life of the mortgage. Your friend has shown you a sample amortization schedule template (below).

Sample Mortgage Schedule

PAYMENT NUMBER

PRINCIPAL AMT. AT THE BEGINNING

(PERIOD) PAYMENTS

INTEREST COMPONENT OF (PERIOD) PAYMENT

PRINCIPAL COMPONENT OF (PERIOD) PAYMENT

PRINCIPAL AMOUNT AT END OF PERIOD

1

Beginning principal

Ans in part a)i

= Effective Period Rate * Principal Amt at beginning of period

= (Period) Payment less Interest Component

= Principal (beg) less Principal Component of (Period) Payment

2

= principal at end of previous period

 

 

 

 

a) Prepare a mortgage amortization schedule to illustrate how the mortgage will be repaid over the next 20 years and calculate the following:

i. What is the amount of your weekly payment?

ii. How much will you pay in total on your mortgage over the life of your mortgage?

iii. What is total interest that will be paid over the term of your mortgage?

iv. How much principal will you have paid off during the initial term of your mortgage?

v. Use the amortization table to determine the first payment where the interest portion of the payment is less than 50% of the total payment. Identify the payment number where this occurs.

2. Lawrence, a family friend (from Ontario) has asked if you would help him fill out his 2015 Income Tax return. He has a very simple return. His employment income from his full time job as a sales representative was $185,250 in 2015. He paid the full allocation to CPP and EI in 2015. As well, he made the maximum RRSP contribution allowable during the year (he has no unused contribution room). After probing further, he also provided documentation of his charitable contributions that added up to $18,500 for the year and he has received $4,350 in dividends from Canadian Corporations.

Lawrence noted he has a diversified portfolio of securities with a market value of $70,000 and an ACB (adjusted cost base) of $50,000. He expects an average compound growth rate of the value of the portfolio to be 8% p.a. He has been trying to decide on if he should sell the portfolio now, pay tax, and reinvest the remainder, or he could hold on without selling until he retires in 14 years. In either case he will sell everything at the end of 14 years.

a) Prepare a T1 General, Federal Tax Schedule 1 and an Ontario Tax (ON 428) for the tax year 2014 for Lawrence.

b) How much more money will he have in 14 years, after tax, if he chooses to hold everything until then instead of selling now and reinvesting. Note: for these calculations assume his marginal tax rate is 40% and average rate is 27% now and then.

3. Should You Rent or Buy?

Bobby and Mary are considering buying a $375,000 one-bedroom home. They have saved up 80,000 to be used as a down payment and for covering closing cost (estimated to be about $10,000). The bank has offered them a first mortgage at an interest rate of 4.75% p.a., to be amortized over 25 years. Apart from the monthly mortgage payments, the property taxes are $3,750/year, Insurance premium $450/year and Condo fees of $495/month.

Alternatively, they can rent the condominium at $1,500/month with rent increase of 4% per year. As well, property tax, insurance premiums and condo fees are expected to increase by the same rate. Note, they can invest their money and earn an after-tax rate of return of 5.5%.

The planning period is three years.

a) Should they rent or buy?

Attachment:- Finance Assignment.zip

Reference no: EM131297002

Previous Q& A

  Discuss the significance of the special covenant

"The Role of the Torah and Special Covenant" Please respond to the following: Discuss the significance of the "special covenant" between the Jewish people and God. Name at least two examples of this covenant in the Jewish religion.

  Greg and noelle both work at comcast

Greg and Noelle both work at Comcast. In the year 2016, Greg makes $75,000 and Noelle makes $140,000. How much in total does each pay in social security taxes?

  Recommend an appropriate form of business ownership

Recommend an appropriate form of business ownership for Four physicians wish to start a practice together, and each wants to have limited liability.

  Which descriptions defines family in its most common form

Which of the following descriptions defines the family in its most common form? What period of human development brings the most rapid time of change?

  How many workers are employed in your agency

What kinds of clients are served by the agency include age range, gender, ethnic background, and needs of the clients?How many workers are employed in your agency? What are the hours of operation?Is there a training program available for the new wor..

  Getting to the bottom of triple bottom line

In the article, "Getting to the Bottom of Triple Bottom Line," Wayne Norman and Chris MacDonald explore the concept of the Triple Bottom Line pattern (3BL).

  Most common form of business ownership in your hometown

What basic steps must be undertaken to organize a corporation in your state?- Discuss and give examples of what you believe is the most common form of business ownership in your hometown ?

  Budgeting for a marketing plan using an xcel spreadhseet

What is the best way to complete 3-5 year forecast and budgeting for a marketing plan using an Xcel spreadhseet?

  Explain how a recession would affect your business

Discuss the advantages and disadvantages of starting your own business compared to buying a franchise?- Explain how a recession would affect your business versus a business with a more diversified product line.

  Summarize the principle components of ethical system

Summarize the principle components of each of the seven ethical systems studied in this course (listed above), including the principle ethicist involved in developing the system. Use two or three sentences for each ethical system.Which ethical sys..

Reviews

len1297002

12/1/2016 5:38:13 AM

Need correct answers with explanation in words and if you did any calculation in excel please put it in words with word. If you make any assumptions to solve the problem, clearly state them at the beginning of the solution and explain the reason. The assignment may be done either individually or in groups of up to three students. If you are doing the assignment in a group, please clearly identify all members.

Write a Review

 

Similar Q& A

  Calculate total depletion and first-year depletion deduction

Calculate the total depletion and first-year depletion deduction given that the land can be salvaged for $10,000.

  What are the potential profits and losses

The price of a stock is $46 and the prices of call options to buy the stock at $45 and $50 are $6 and $3, respectively. What are the potential profits and losses when the price of the stock is $40, $45, $50, and $55 if the investor buys the call a..

  The fed versus congress

The Fed versus Congress: - Should the Fed or Congress decide the fate of large financial institutions that are near bankruptcy?

  Determine the rate for a forward contract on the euro

A company called American Banking and Trading has entered into a long forward contract to buy 10 million British pounds at a price of $1.55. The contract has five months to go.

  Assess and critique the positions of both the skeptics and

equity valuations in todays market are arguably too high. many analysts assert that price-toearnings ratios are so high

  How does zero-based budgeting differ from standard budgeting

How does zero-based budgeting differ from standard budgeting procedures? What are some potential advantages of zero-based budgeting? What are some potential disadvantages of zero-based budgeting?

  Develop a suitable null and alternate hypothesis

A manager randomly samples 60 containers of juice. The manager is concerned that the containers may be filled to an amount different from 30 ounces. a) Develop a suitable null and alternate hypothesis. b) How can the manager make a Type I error? c) H..

  What can be said about leverage associated with the property

A property is financed with a 75% loan at 11.5% over 25 Years. The property produces an ATIRR on total investment of 7.34% based on a tax rate of 31%. What can be said about the leverage associated with the property?

  You have 12000 in cash you can deposit it today in a mutual

you have 12000 in cash. you can deposit it today in a mutual fund earning 5.7 percent semiannually or you can wait

  The project will cost 150000 and will be depreciated

ernies electrical is evaluating a project which will increase sales by 50000 and costs by 30000. the project will cost

  Difference between defined benefit and contribution

Determine the difference between defined benefit and defined contribution and also define derivatives.

  Describe the value of branding for both the buyer and the

describe the value of branding for both the buyer and the seller. how would you go about developing a brand for cloud

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd