Solution-Calculate the interest charges for the years

Calculate the interest charges for the years

Reference no: EM132613817

Instruction: For the following questions, with the help of the formulas learnt in topic 1 and 2, you are to use excel and calculate:

1. You plan to borrow $15,000 for a 10-year term, at 15% simple interest per annum. Calculate the interest charges for each of the years and the accumulated amount at the end of each year in excel using tables.

2. You plan to borrow $15,000 for a 10-year term, at 15% compound interest per annum. Calculate the interest charges for each of the years and the accumulated amount at the end of each year in excel using tables.

3. An investor deposits $20,000 into a savings account for 2 years that earns 4% annual interest, compounded monthly. Calculate the interest charges for each of the period and the accumulated amount at the end of each period in excel using tables.

4. Find the future value of an annuity, that pays $25,000 at the end of each year for 11 years at 9%, using excel.

5. Calculate the present value of an annuity, that pays $5,000 per year for 8 years at 5 percent assuming that the first payment is made after 2 years, using excel.

Reference no: EM132613817

Questions Cloud

How the asset will be accounted for in financial statements : How the asset will be accounted for in the 2015 financial statements ( Statement of Profit and Loss for 2019 and Statement of financial position)

Operations management and project management : Many universities, industry professionals, and organizations feel that operations management and project management go hand in hand.

Determine the annual interest costs : Genetech has $2,000,000 in assets, have decided to finance 30% with long-term financing (13% rate) and 70% with short-term financing

Advise wisdom ltd on the treatment of the grant : Advise Wisdom Ltd on the treatment of this grant in the 2019 financial statements ( Statement of Profit and Loss for 2019 andStatement of financial position)

Calculate the interest charges for the years : You plan to borrow $15,000 for a 10-year term, at 15% simple interest per annum. Calculate the interest charges for each of the years

Outcomes of organizations you know of or have worked : What are some of the structures, processes and outcomes of organizations you know of or have worked in? How are these areas successful or unsuccessful

Explain the treatment of the building in financial statement : Explain the treatment of the building in the 2019 financial statements on the assumption that the entity uses the fair value model for investment properties.

How many czech crowns : If a Czech crown is equal to $.04, the U.S. dollar is equal to how many Czech crowns?

Nature of external environment surrounding company : Identify the company's internal strengths and weaknesses. Explain the nature of the external environment surrounding the company.

User Account

All Pages

Calculate the interest charges for the years

Reference no: EM132613817

Reference no: EM132613817

Questions Cloud

Reviews

Write a Review

Finance Basics Questions & Answers

Financial reporting and analysis

A report on financial accounting

Describe the types of financial ratios

Differences between sole proprietorship and corporation

Prepare a cash budget statement

What are the implied interest rates

State pricing theory and no-arbitrage pricing theory

Small business administration

Effect of financial leverage

Evaluate the basis for the payment to the lender

Importance of opps, ipps, mpfs and dmepos

Time value of money

Assured A++ Grade

Academics

Major Subjects

Majors

Get In Touch

TERMS & POLICIES

HELP & SUPPORT