Assessment 1 - TAFE NSW



Assessment Instructions Unit: FNSACC303A: Perform Financial CalculationsAssessment 1Assessment mode: written assessmentFNSACC303A: Assessment 1Instructions: To complete this assessment you will be required to use a number of resources including a hand held calculator, Excel and online special purpose calculators. There is also a workbook you can reference to provide you with an understanding of how to perform the financial calculations required in this assessment.There are 13 questions you need to complete for this assessment. There are 3 Sheets in the Answer Sheet and all 3 sheets need to be completed.You need to:Open the Answer Sheet for Assessment 1, Copy it Save itName your file with your surname/family name followed by Assn1_FNSACC303A. Put your surname at the start of the file name e.g. SMITHAssn1_FNSACC303A. Type your surname and first name in the box on the first page of Answer Sheet Assessment 1.Enter your answers and show your workings out.When you have completed the assessment you need to upload your file to Sakai for marking.Task 1 – Workplace Calculations Note – it is essential for this assessment to show all workings. Question 1(6 marks)Personal tax rates for 2014-15. These rates do not include the Medicare Levy of 2%.Taxable incomeTax on this income0 – $18,200Nil$18,201 – $37,00019c for each $1 over $18,200$37,001 – $80,000$3,572 plus 32.5c for each $1 over $37,000$80,001 – $180,000$17,547 plus 37c for each $1 over $80,000$180,001 and over$54,547 plus 45c for each $1 over $180,000Use the Personal Tax rates above for 2014-2015 (which excludes the Medicare Levy) to calculate the Personal income tax payable on the following amounts – workings must be shown.a.$16,550b.$48,896c.$82,500Question 2(2 marks)What would the Medicare Levy be on a Taxable income of $48,896? (calculation to be shown)Question 3 - GST(4 marks)a. Calculate the GST that will apply to a product costing $48,500 ex GST.b. If an item with a value of $15,950 includes GST, what is the value of GST?Question 4 - Mark up(8 marks)If an article has a net (or cost) price of $25 and the mark up is 22.5% on net price, what is the marked up price on the article? (Ignore GST on this question). Round to nearest 5c.A product has a net (or cost) price of $85 and is sold for $125. Find the mark-up in whole dollars. Ignore GST.A product has a net (or cost) price of $25 and is sold for $45. What is the percentage mark-up on net? Round to a whole number percentage. Ignore GST.If a product has a selling price of $85 and the mark up is 25.5% on net price. What is the net(cost)price on the article? Ignore GST and round to 2 decimal places.Question 5 - Break Even(2 marks)What is the name of the point in a business when profit begins to be returned?Fixed pointVariable pointBreak-even pointNone of theseQuestion 6 – Depreciation(4 marks)A company buys a new digital printer for $28,500 on 1 January 2011. The company’s financial year end is 31 December. The scrap (salvage/residual) value is $2,500. Prepare a depreciation schedule for the first 5 years. The straight-line depreciation rate is 20%. Ignore GST. Note: Go to sheet 2 (separate tab) of the Answer sheet to complete this table.YearBook value atbeginning of year ($)AnnualDepreciation ($)Book value atyear end ($)CumulatedDepreciation ($)20112012201320142015Question 7 - Inflation(2 marks)Are interest rates and inflation linked?YesNoQuestion 8(6 marks)Match the following words to their definition:InterestPrincipalInflationThe amount of money that has been borrowed or investedThe amount of money paid for the privilege of using someone else’s money or forgoing the use of your own moneyThe percentage increase in the price of commodities over time. Generally these price increases have a direct bearing on the interest rate.Question 9 – Simple Interest(13 marks)The amount of money paid or received as interest depends on what 3 factors?Calculate the amount of interest paid on a loan with the following variables – round to whole dollars – use simple interest.Principal:$5,500Rate:11%Period:5 yearsCalculate the amount of interest paid on a loan with the following variables – round to 2 decimal places – use simple interest – assume 365 days in the year.Principal:$10,500Rate:17.25%Period:60 daysCalculate the maturity value of an investment with the following variables – round to whole dollars – use simple interestPrincipal:$60,000Rate:7 %Period:20 monthsCalculate the simple interest rate charged on the following investment – round to 2 decimal places.Investment value:$14,000 Returns:$24,000Period:42 monthsWhat principal amount will be needed to earn 4.5% on the following: Interest:$6,615Rate (pa %):4.5%Period/time:42 monthsQuestion 10 – Compound Interest(8 marks)Calculate the amount of interest paid for the following loan using compound interest – round to whole dollars – compound annuallyPrincipal:$10,500 Interest rate:17%Period:4 yearsWhat would be the period interest rate (r) and number of interest periods (n) on the following investment?Rate per annum (%):18% Adjustment period:6 monthly Length of investment: 42 monthsDetermine the period interest rate (r) and the number of interest periods (n) if a deposit for 5 years, earns interest of 12% pa compounded annually?Question 11 – Order of Operations(4 marks)Answer the following using the correct order of operations:18 + 6 x 410 ÷ 2 x 518 ÷ 3 – 1 x 4(5 + 2) x (8 – 5)Question 12 – ATO online calculator(6 marks)Go the Australian Taxation Office website on the Comprehensive tax calculator 2014 and click start.Answer the following Tax to be paidTax on taxable incomeMedicare LevyBased on:A gross income of $65,200Resident for a full yearSingle, with no dependentsPaying the Medicare levy surchargeNote: Select YES for Medicare levy surcharge and leave all others unchecked.Question 13- Excel(4 marks)Go to Sheet 3 Q13, of the Answer sheet (see bottom tab).Calculate the selling price of Asia Hut’s meals based on a mark up of 35%. Format columns D & E to currency, rounded to whole dollars and right justify. You must use cell references in your formulas.Asia Hut Selling PriceMark up percentage ?Q13.ItemMealCost per itemSelling Price101Stir fry with rice - small10?102Stir fry with rice - medium12?103Stir fry with rice - large14?104Stir fry with noodles - small11?105Stir fry with noodles - medium13?106Stir fry with noodles - large15?107Dumplings15?On the same spreadsheet, produce a line chart (graph) of Asia Hut’s sales for 2014. Select data in table, click on charts, line. Add a title to the chart then save. Asia Hut Sales by Value 2014?Rice $Noodles $Dumplings $Total $JAN42564456331050098697FEB3584838444865082942MAR2654829853755063951APR1985224687690051439MAY3655636551925082357JUN2541827498865061566JUL2289228632655058074AUG436764825412150104080SEP34198369521240083550OCT2986430295750067659NOV3269835741825076689DEC2985032598850070948 ................
................

In order to avoid copyright disputes, this page is only a partial summary.

Google Online Preview   Download