Determine the size of the semi-annual payments

Reference no: EM131948926

Question 1: An amortization

Ahmad borrowed $450000.00 at 3% compounded semi-annually for ten years to buy an apartment. Equal payments are made at the end of every six months.

a) Determine the size of the semi-annual payments.

b) Prepare an amortization schedule showing the details of the first two payments and the totals of all payments.

c) Use Excel to create an Amortization Schedule showing the details of all payments and the totals of all payments. Print and attach your Excel worksheet.

Question 2: A sinking fund

A sinking fund amounting to $450000.00 is to be created by making deposits at the end of every six months for ten years. Interest earned by the fund is 3% compounded semi-annually.

a) Determine the size of the semi-annual deposits.

b) Prepare a sinking fund schedule showing the details of the first three deposits and the totals of all payments.

c) Use Excel to create a sinking fund schedule showing the details of all payments and the totals of all payments. Print and attach your worksheet.

Reference no: EM131948926

Questions Cloud

Responds to economic development : The operation of the financial sector merely responds to economic development, adjusting to changing demands from the real sector and is therefore

What are annual storage costs associated with EOQ model : AIA Inc. is looking to manage its cash position using the EOQ model. What are the annual storage costs associated with the EOQ?

What was the role of foreign subjugation : Address the role of history in understanding your culture. What was the role of foreign subjugation, wars, visions of world domination, etc?

Discuss the factors that affect the aggregate supply : Discuss the factors that affect the aggregate supply (shift the aggregate supply curve) and the factors that affect the aggregate demand.

Determine the size of the semi-annual payments : Determine the size of the semi-annual payments and Prepare a sinking fund schedule showing the details of the first three deposits and the totals of all payment

Downward sloping demand curve : Assume that you are managing a monopoly. Your monopoly faces a downward sloping demand curve described by the equation P = 85 - 5Q.

How much was his total social security tax : how much was his total social security tax? Of this, how much did his employer pay in social security taxes for Charlie?

Monopolies and new entrants : Snack food venders and beer distributors earn some monopoly profit in their local markets but see them slowly erode from various new substitutes.

What is the equipment after-tax salvage value : What is the equipment’s after-tax salvage value for use in a capital budgeting analysis?

User Account

All Pages