Get Instant Help From 5000+ Experts For

Writing: Get your essay and assignment written from scratch by PhD expert

Rewriting: Paraphrase or rewrite your friend's essay with similar meaning at reduced cost

Editing:Proofread your work by experts and improve grade at Lowest cost

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
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.