Question: show excel work please question 1 )Your parents opened a brokerage account with TD Ameritrade in 2015 when they deposited a check for $10,000. In

show excel work please

question 1 )Your parents opened a brokerage account with TD Ameritrade in 2015 when they deposited a check for $10,000. In 2016 they sent them another check for $12,000 and the same amount of $12,000 in 2017. The next check was in 2019 in the amount of $20,000.

question 2)

You are the chief investment analyst at ABC Corporation. The company would like to undertake some projects if the net income from these projects can meet the company expected rate of return of 12%. Use your skills in computing the NPV
of the following projects. (10 marks)
Build Office Install Production Line Purchase a Truck Build a Carpark
Initial cost 30,000,000 36,000,000 1,500,000 2,000,000
Net Income
Year 1 4,200,000 12,150,000 650,000 325,000
Year 2 6,500,000 12,850,000 625,000 350,000
Year 3 9,500,000 8,100,000 500,000 360,000
Year 4 11,000,000 8,000,000 380,000 400,000
Year 5 12,500,000 7,850,000 300,000 350,000

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Accounting Questions!