Calculate the repayment amount and total interest amount

Assignment Help Finance Basics

Reference no: EM131839110

Answer all the questions using MS Excel Spreadsheet. You must print the assessment for submission and also upload copy of your Excel Spreadsheet into AHIC Moodle.

Q1. You are the Finance Manager for Andy & Co and have received the approval to borrow $200,000 with interest rate settled @5% p.a. The loan is for a period of 5 years. And to be repaid monthly. Calculate the repayment amount and total interest amount for the loan.

Q2. Andy & Co has also got a car loan of $25,000 for 3 years with interest rate settled @8% p.a. to be compounded quarterly. Calculate the accrued amount for the loan.

Q3. As on 31st May, 2016, Andy &Co's loan account shows a balance of $5,100. The company made the minimum monthly payment of $100 for the month of June on 1st June. Calculate the interest amount accrued for June by considering the interest rate of 6% p.a.

Q4 Using the following information of Andy & Co, calculate the Annual Break Even Point (BEP).
- Capacity of manufacturing is 2000 units per month
- Fixed Cost per month is $50,000
- Selling price per unit is $100
- Variable cost per unit is $50

Q5. Using the information below calculate the depreciation amount per year for an equipment.
- Purchase price was $40,000.
- Salvage value is $10,000.
- Expected useful life is 5 years.

Q6. Using simple interest method, how much interest will you pay if you borrow $20,000 for 2 years at an interest rate of 5% p.a.

Reference no: EM131839110

Questions Cloud

Explain the major potential risks of the prospective deal : A Chinese firm approaches your CEO in order to license the technology. Outline the major potential risks and benefits of the prospective deal for your CEO.

Calculates partial year depreciation : On April 30, 2018, Quality Appliances purchased equipment for $262,000. Quality calculates partial year depreciation based on the number of months

Terms of disaster recovery : In terms of disaster recovery, what are the seven elements that need to be considered during and after a disaster?

Compare jdbc with in-memory authentication : Without copying and pasting from the internet compare JDBC with In-Memory Authentication

Calculate the repayment amount and total interest amount : FNSACC303-Perform Financial Calculation - Calculate the repayment amount and total interest amount for the loan and Calculate the interest amount accrued

Is the political environment fostering long-term investment : Locate two websites that provide country analysis outlining investment opportunities and, in particular, the political climate for investment.

Government help private organizations : Should the U.S. government help private organizations that are attacked (or allegedly attacked) by foreign governments? Why or why not?

What equipment would be useful in given situation : You are the emergency manager in a city that is having a parade. You are concerned about protestors or terrorist attacks because controversial groups.

What is the impact on stakeholders across the organization : During the implementation of a Clinical Information system, what is the impact on stakeholders across the organization?

User Account

All Pages