User Account

All Pages

Calculate how much interest Mr Smith has paid

Assignment Help Financial Accounting
Reference no: EM132786706

Question - LOAN REPAYMENT QUESTION IN EXCEL

Mr John Smith takes out a $45,000 car loan at 4% annual interest to be repaid over 4 years (48 equal installments).

On the third day of month 14 the loan rate is reduced to 3.5%.

Calculate how much interest Mr Smith has paid at the various rates (including the mixed monthly rates when the rate changes take place).

Also calculate the TOTAL INTEREST paid over the entire duration of the loan repayment.

Reference no: EM132786706

Questions Cloud

Prepare a cash budget for the month of march : Prepare a cash budget for the month of March 2021. The business plans to take out a small business loan of $50,000 at the end of March 2021
Who do you think is right : a) Who do you think is right? Explain why. b) Is it possible tha t Mario and Lucia could be worse off than two years ago?
How image conveys an important point in american history : Your final project will be a PowerPoint (or other multimedia) presentation, complete with text, pictures, and sounds and/or music.
What interest payments will bondholders receive each year : A $1,000 General Electric bond pays an annual coupon rate of 8%, has 9 years until maturity, What interest payments will bondholders receive each year
Calculate how much interest Mr Smith has paid : Calculate how much interest Mr Smith has paid at the various rates (including the mixed monthly rates when the rate changes take place)
Post relevant transaction to the sales revenue ledger : Daniel runs an optical store "D Only Opt", Post relevant transaction(s) to the 'Sales Revenue' ledger and calculate the balance at 31 January 2021.
Discuss the transformations that occurred as a result : Artists are often involved in national social movements that result in the transformation not only of the art world, but also of society at large.
What are the three types of reserves : What are the three types of reserves? and what are reserve requirements based upon?
What would Cyrus profit or loss be on the bond : What would Cyrus's profit or loss be on the bond if he sold it when yields dropped to 4%? What was his return on his investment

Reviews

Write a Review

Financial Accounting Questions & Answers

  Financial statement analysis and preparation

Financial Statement Analysis and Preparation

  Shareholder of a company

Describe the ways that a person can become a shareholder of a company. Why Wal-Mart would split its stock?

  Financial and accounting principles

An understanding of financial and accounting principles can be a valuable tool for managers. While not all managers will find themselves calculating financial ratios or preparing annual financial data.

  Prepare a statement of cash flow using the direct method

Prepare a Statement of Cash Flow using the Direct Method and Prepare the Operations section of the Statement of Cash Flow using the Indirect Method.

  Financial accounting assignment

This assignment has one case study and two question apart from case study. Questions related to document Liquidation question and Company financial statements question - Torquay Limited

  Prepare general journal entries for goela

Prepare general journal entries for Goela Ltd

  Principles of financial accounting

Prepare the journal entry to record the acquisition of the assets.

  Prepare general journal entries to record the transactions

Prepare general journal entries to record the transactions, assuming use of the periodic inventory system

  Global reporting initiative

Compare the view espoused by the economist Milton Friedman about the social responsibilities of business with the views express by Stigler.

  Explain the iasb conceptual frameworks

Explain the IASB Conceptual Framework's perspective of users and their decisions.

  Determine the company''s financial statements

T he focus of the report is to determine the extent to which you are comfortable relying on the financial statements as presented by management .

  Computation of free cash flow

Computation of Free Cash Flow

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