Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

i need excel sheet calculations with each step shown, thank you In 1880, five aboriginal trackers were each promised the equivalent of 100 Australian dollars

i need excel sheet calculations with each step shown, thank you
image text in transcribed
In 1880, five aboriginal trackers were each promised the equivalent of 100 Australian dollars for helping to capture the outlaw Ned Kelly. In 2017, the granddaughter of one of the trackers claimed that the reward has not been paid yet. 1. If the average interest rate is 5 percent per annum, how much this 100 has accumulated to? 2. The government decides to give the granddaughter a payout with an implied interest of 5 percent per year, she then borrows the remaining from the bank to make a total of 200,000 and uses the whole 200,000 to buy Westfarmers stocks (Ticker WES.AX in Yahoo Finance and Au:WES in MarketWatch) at the price 32.08 on the 1st of March 2017. The interest from the bank is 3% per annum. She does not need to pay interest until the shares are sold i.e. interest is capitalised to the amount that she borrows. On the 1st of March 2022, she decides to sell Westfarmers shares at the closing price and pay-off the debt. How much money does she have left after paying out the loan, what is her average annual return

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Security Of Computerisation In Accounting And Auditing System

Authors: M.S. Baghel

1st Edition

8178801132, 978-8178801131

More Books

Students also viewed these Accounting questions