FNSACC323 - Perform Financial Calculations Assignment

Assignment Task

Part 1: Break even

Task 1

To complete this part of the assessment, you will be required to open the excel workbook and within the correct worksheet, fill in the missing numbers for items 1 to 3.

Round your answer to the nearest cent, or sales unit. For example, 3.392 would be expressed as $3.39, or 3 units.

Part 2: Depreciation

Task 1

A training organisation purchases a heavy volume copier for large workloads on 1/7/2022 for $36,000 [GST exclusive]. It has a useful life of 4 years and a residual value of $4,000 [GST exclusive]. Produce a depreciation worksheet using straight line depreciation.

To complete this part of the assessment, you will be required to open the excel workbook and within the correct worksheet, fill in the missing numbers for financial years 2023 to 2026.

Part 3: GST

Task 1

The GST rate is 10%.

To complete this part of the assessment, you will be required to open the excel workbook and within the correct worksheet, fill in the missing numbers for items 1 to 5

Task 2

Stationery Works has just received a shipment of goods from the warehouse.

To complete this part of the assessment, you will be required to open the excel workbook and within the correct worksheet, fill in the missing numbers for items 1 to 5..

Fill in columns F – H by completing the following tasks for each item:

• calculate the GST amount for each item that is liable for GST
• calculate the selling price, excluding GST
• calculate the selling price, including GST.

Round your answer to the nearest cent. For example, 2.494 would be expressed as $2.49.

Task 3

To complete this part of the assessment, you will be required to open the excel workbook and within the correct worksheet, fill in the missing numbers for items 1 to 5.

Refer to the ATO website to verify the input data in column E for which items are liable for GST and repeat Task 2. You must complete column E in the table, as well as columns F to H as above.

Part 4: Income tax, mark-up and margin

Task 1

To complete this part of the assessment, you will be required to open the excel workbook and within the correct worksheet, fill in the missing numbers for items 1 to 3 in columns C and D.

You have been provided with the income tax rates for each tax bracket in the same excel spreadsheet, columns F and G. Verify this input data and confirm it is accurate as required for workplace calculations.

Round your answer to the nearest cent. For example, 2.494 would be expressed as $2.49.

Task 2

To complete this part of the assessment, you will be required to open the excel workbook and within the correct worksheet, fill in the missing numbers for items 1 to 3.

Round your answer to 2 decimal places. For example, 2.494 would be expressed as 2.49.

Part 5: Simple and compound interest

Task 1

To complete this part of the assessment, you will be required to open the excel workbook and within the correct worksheet, fill in the missing numbers for items 1 to 4.

Complete the table by calculating the interest payable on the following amounts using simple interest.

Do not show the accumulated interest.

Task 2

To complete this part of the assessment, you will be required to open the excel workbook and within the correct worksheet, fill in the missing numbers for items 1 to 4

Complete the table by calculating the interest payable on the following amounts using compound interest.

Do not show the accumulated interest.

Round your answer to the nearest cent. For example, 2.494 would be expressed as $2.49.

Part 6: Storing calculation worksheets

Once you have completed Part 1 to Part 5 of this assessment, you need to store your files according to organisational policies and procedures.

This Accounting and Finance has been solved by our PhD Experts at My Uni Paper. Our Assignment Writing Experts are efficient in providing a fresh solution to this question. We are serving more than 10000+ Students in Australia, the UK, and the US by helping them to score HD in their academics. Our Experts are well-trained to follow all marking rubrics and referencing styles.

Be it a used or new solution, the quality of the work submitted by our assignment experts remains unhampered. You may continue to expect the same or even better quality with the used and new assignment solution files respectively. There’s one thing to be noticed you could choose one between the two and acquire an HD either way. You could choose a new assignment solution file to get yourself an exclusive, plagiarism (with free Turnitin file), expert quality assignment or order an old solution file that was considered worthy of the highest distinction.