FNSACC511 Provide Financial and Business Performance - Product Assessment Task

Get Expert's Help on BSBITU402/FNSACC511 Accounting

Product Assessment Task

Part B: Short Case Studies

Question 2
Pixel Limited Case Study
Pixel Ltd has asked you to evaluate an investment option which they are considering investing some vacant funds in. If they invest $4800 at the end of each year for 10 years, they will receive $84,230 at the end of that time. Pixel Limited has advised that they will go ahead with the investment if the interest earned on the investment is greater than 14.5%.

You are required to complete the following:

  1. Calculate the interest rate, which will be earned on the above investment. Evaluate information in relation to the financial profitability.
  2. Calculate the value of interest earned over the 10 years. Based on your calculations should Pixel Limited go ahead with the above investment? Please provide a justification for your suggestion.
  3. You are required to insert the above data into a spreadsheet clearly labelling all cell references as well as worksheets. Please use formulas/ functions to perform all mathematical calculations in the worksheet clearly showing all workings. Please note your work will be crosschecked against the input you have put in the cells. You are also required to represent your suggestions in graphical form and are required to link/embed this chart to your analysis in the corresponding work document as per MS Office 2019 or 2016 procedures.

Hire an Expert Tutor for this Answer

Hire Expert Tutors

Get Professional Tutoring at Low Price in Australia


Professional

Tutoring Services

25,187+

Orders Delivered

4.9/5

5 Star Rating

621

PhD Experts

 

Amazing Features

Plagiarism Free

Top Quality

Best Price

On-Time Delivery

100% Money Back

24 x 7 Support

TOP