FNSACC303-Perform Financial Calculation

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.

Impact of inflation on the following products are
Basket of goods – 22*137/100 =30.14
    Motor vehicle 22500*137/131=235300.53
Bread1.50*137/125=1.644
House 495000*137/133= 509887.218

Formulae of Simple interest are
S.I – Principle *rate * time /100
1. First,convertingR present to r a decimal
r = R/100 = 7%/100 = 0.07 per year,
then, solving our equation

A = 10000(1 + (0.07 × 1)) = 10700
A = $ 10,700.00

Thetotalamount accrued, principal plus interest,
from simple interest on a principal of $ 10,000.00
at a rate of 7% per year
for 1 years is $ 10,700.00.
2. First, converting R present to r a decimal
r = R/100 = 6.75%/100 = 0.0675 per year,
then, solving our equation

A = 12410(1 + (0.0675 × 2.5)) = 14504.1875
A = $ 14,504.19

The total amount accrued, principal plus interest,
from simple interest on a principal of $ 12,410.00
at a rate of 6.75% per year
for 2.5 years is $ 14,504.19

The formulae for compound interest are
 

a.1157.625
b.3931.95

Mark-up is when a business produces or procures a good at one price and then sells the product for an advanced price. Having a good mark-up helps a company to earn good profits all over (bride, 2017)The mark up on the following are
1.$50(250*25 /125)
2. $ 2.41  ($9.30*35/135)
Note : We cannot consider it as cost price as its written with mark-up.

Straight line depreciation is a depreciation method where the asset is depreciated over the useful life minus any scrap value or residual value.
Equipment purchased $5000 , life 4 years  estimated scrap value- $ 600
5000-600/4-=1100 each year depreciation
2000-500/3= 500 each  year depreciation

The workplace tools where we can perform calculations are Microsoft excel, Finance software which actually depends on company to company, and Micros wizard.

The 3 places are the income tax sites, the other articles or journals relevant to that subjects, or the annual report.

The three mistakes that arise due to financial calculations are:
The purchase invoices are not In proper phase. For example every solitary acquisition statement that we put into the records should be chequered initially. We should  see that did we  really receive the properties or services billed? Is the statistics precise? If the prices that are charged are they correct? Any tax on the invoice are correctly shown or not, if it then are they matching with the returns and also to see if all the invoice add up.
The customer issue, numerous trades issue sales statements to their clienteles. Clienteles usually take one or two months to pay demands or invoices, and when it is paid they pay you for one or more invoices at once. we need to pay vigilant consideration to  payers that are late, for various reasons. It can indicate that the customers have become financially unstable or the customers have been disputing the invoices. Therefore proper customer accounts needs to be checked at intervals