Calculate the interest expense in the third year

Assignment Help Financial Management
Reference no: EM132331638

Requirement

Using the present value of an ordinary annuity table, calculate the payment amount and complete the amortizatic

Use the effective interest amortization method.

a. Calculate the loan payment by dividing the loan amount by the appropriate present value factor.

b. Round values to two decimal places. Calculate the interest expense in the third year as the loan payment minus the loan balance at the begin.

c. Use absolute cell references and relative cell references in formulas.

Payment(using PV table) $13,093.90

Period

Beginning Balance

Principal Payment

Interest Expense

Total Payment

Ending Balance

0

 

 

 

 

$ 35,000.00

1

$ 35,000.00

$10,993.84

$2,100.00

$13,093.84

$ 24,006.16

2

24,006.16

$11,653.47

$1,440.37

$13,093.84

$ 12,352.68

3

12,352.68

$12,352.68

$741.16

$13,093.84

$ -

Total

 

$35,000.00

$4,281.53

$39,281.53

 

Reference no: EM132331638

Questions Cloud

Light of changing patterns of drug taking behavior : "What's new is sometimes really old." Discuss this statement in light of changing patterns of drug taking behavior over the last fifty years.
Basic computer science : Basic Computer Science: Which of the following statements is true about data structures?
Circumstances and problem faced by healthcare organization : Provide brief summary of the circumstances and the problem(s) faced by the healthcare organization. Highlight details you believe to be of particular relevance
Pros and cons of use and impact on the environment : Accessibility in the United States. Initial and long-term costs. Pros and cons of use. Impact on the environment.
Calculate the interest expense in the third year : Calculate the loan payment by dividing the loan amount by the appropriate present value factor. Calculate the interest expense in the third year.
Draft system vision document for the farm information system : Prepare a draft System Vision Document for the Farm Information System and Either by yourself or with another class member, brainstorm all the functions
What are key components in protecting computer : What are key components in protecting your computer (internal LAN, Intranet, etc.) from outside threats? Site sources.
Paper argumentative essay : Paper Argumentative Essay. Animals in the zoo. Is it fair to keep them in cages? Instructions: research and argue that it is not fair to keep animals in cages.
Code for a mortgage loan calculator : I was thinking of utilizing arrays for multiple users that will give the payment amount after the input loan amount, interest rate and years to repay.

Reviews

Write a Review

Financial Management Questions & Answers

  Foreign company acquisition

Acquisition by a foreign company and the effects of that decision and the results of foreign exchange in Euro and the exchange rate differences.

  Financial management for profit and non profit organizations

In this essay, we are going to discuss the issues of financial management in a non-profit organisation.

  Method for estimating a venture''s value

Evaluate venture's present value, cash and surplus cash and basic venture capital.

  Replacement analysis

This document show the Replacement Analysis of modling machine. Is replacement give profit to company or not?

  Business finance task - capital budgeting

Your company is considering using the payback period for capital-budgeting. Discuss the advantages and disadvantages of this technique.

  Analysis of the investment

In this project, you will focus on one of these: the additional cost resulting from the purchase of an apple press (a piece of equipment required to manufacture apple juice).

  Conduct a what-if analysis

Review the readings and media for this unit, including the Anthony's Orchard case study media. Familiarise yourself with the Anthony's Orchard company and its current situation.

  Determine operational expenditures

Organisations' behaviour is guided by financial data. In the short term, such data will help determine operational expenditures; in the long term, historical data may help generate forecasts aimed at determining strategic plans. In both instances.

  Personal financial management

How much will you have left over each half year if you adopt the latter course of action?

  Sources of finance for expansion into new foreign markets

A quoted company is considering several long-term sources of finance for expansion into new foreign markets.

  Long term financial planning

This assignment is designed for analyze Long term financial planning begins with the sales forecast and the key input in the long term fincial planning.

  Explain the role of fincial manager

This assignment explain the role of fincial manager, function of manger. And what are the motives of financial manager.

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