User Account

All Pages

Determine the size of the semi-annual payments

Assignment Help Mathematics
Reference no: EM131987456

Question 1: An amortization

Ahmad borrowed $450000.00 at 3% compoundedsemi-annually for ten years tobuy 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 thefirst two payments and the totalsof all payments.

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

Question 2:A sinking fund

A sinking fund amounting to $450000.00 is to be created by making depositsat 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.

Verified Expert

The paper is about how we can use the amortization method and sinking fund method to calculate the repayment plan for one who has borrowed some money for mortgage or purchase of some property. This paper gives solution on how to use amortization method in the first part of the assignment to determine the repayments over a given time schedule. It also demonstrates how to use excel to prepare an amortization schedule that indicates all the payment details. In the second bit of the paper, sunking fund method is used when one wants to create some fund that would be needed at a future date. The method has been used to show how one would know the amount to deposit over a given regular period of time to generate the value required. The paper has been prepared in both Micro Office word document and Microsoft Excel.

Reference no: EM131987456

Questions Cloud

Develop a cohesive reflection addressing all points : Consider the questions that follow below and develop a cohesive reflection addressing all points.
How often would the cycle turn over in a year : A supplier is offering your firm a cash discount of 2 percent if purchases are paid for within ten days; otherwise, the bill is due at the end of 60 days.
Discuss how distribution adds value to the product : Explain the role of distribution in getting a product to customers (store and nonstore).Discuss how distribution adds value to the product.
Goods-producing organization-service-providing organization : Select a goods-producing organization and a service-providing organization of your choice. Suggest ways each organization can make aggregate planning
Determine the size of the semi-annual payments : MTH 102 - Business Mathematics - Determine the size of the semi-annual payments and Prepare an amortization schedule showing the details of thefirst two payment
Management of inventories : From the first e-Activity, examine the best practices found in the video on inventory management.
Explain how will you implement proposed educational session : Explain how will you implement the proposed educational session? What tools will you use to evaluate the proposed educational session?
Analyze contribution margins in one to two page forms : Help me differentiate between incremental and avoidable costs for a client and analyze contribution margins in one to two page forms.
A brief overview about leaders and the leadership theory : Develop a brief overview (i.e., no more than one [1] paragraph for each leader) of the selected leaders and the leadership theory.

Reviews

Write a Review

Mathematics Questions & Answers

  Doctor order within the desired range

The medication label shows that 75-150 mg/kg per day is the appropriate dosage range. Is this doctor's order within the desired range?

  Inventory costs that are consecutive numbers

You have been given two inventory costs that are consecutive numbers and have a sum of 91. What are the two inventory costs? Show your work algebraically.

  Find the production levels needed to satisfy

Find the production levels needed to satisfy the final demand d. (Units are in millions of dollars.)

  Define a bipartite graph g is a simple graph

A bipartite graph G is a simple graph whose vertex set can be partitioned into two disjoint nonempty subsets V1 and V2 such that vertices in V1.

  Projection of a vector onto another vector

Calculate P- and N- by the formulas given above. Use Step I of the Maple supplement to plot your results and to check your calculations. Provide a printout of your Maple plot: include both the blue output as well as the plot.

  Estimate the error in using

Calculate the degree 3 MacLaurin Polynomial, P3(x), for coshx, evaluate P(1) and use the remainder term to estimate the error in using P(1) to estimate cosh(1) (to put an upper bound on the error you should use the fact that 2

  Determining the score which is needed on test

To pass a course, you must have a final average of at least 60%. If a student scores 42 and 74 on the first two tests, what must be earned on the third test to pass the course?

  What is the length and the width in inches

the perimeter of a rectangle is 202 inches the length execeeds the width by 81 inches. what is the length and the width in inches.

  Find probabilities in real life

Can you think of situations in the business world or other real life situations where you would need to calculate or estimate probabilities?

  Alligation alternate and alligation medial

Describe the difference between alligation alternate and alligation medial.

  What is the sign of the error

Find the true value of the function at x = 1. What is the error? (Give decimal answers.) Illustrate with a graph.

  What date did bert repay the loan

Bert borrowed $7500 from Delores on November 7, 1997. When Bert repaid the loan, Delores charged $190.02 interest. If the rate of simple interest on the loan was 6 3/4%, on what date did Bert repay the loan?

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!

Submit Assignment

Academics

Major Subjects

Majors

Get In Touch

whatsapp: +1-415-670-9521

Phone: +1-415-670-9521

Email: [email protected]

TERMS & POLICIES

HELP & SUPPORT

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