Question: could you please answer both questions in full detail with the correct method and explain formulas used in excel to get answers/ tables you got.

could you please answer both questions in full detail with the correct method and explain formulas used in excel to get answers/ tables you got. thank you
could you please answer both questions in full detail with the correct

3. SplashCo Space Company has purchased a launcher system for launching passenger rockets into the edge of space from Norman Wells, NT. The cost of the new system was $250,000 and it has a service life of 10 years. For the first six years, depreciation of the system was calculated using the declining balance method at a rate of 30%. During the last four years, the straight line method was used for accounting purposes to bring the book value to $0 at the end of its service life. Make a table in Excel with the book values at the end of each year. Include the table in your submission to d2. What was the book value of the system after 3,5,7, and 9 years? (5 marks) 4. EncryptCo has two possible plans for accumulating money for capital projects. One plan is to save $100,000 per year, independent of growth. The second plan is to start with $80,000 per year and increase the annual contribution by 5% each year. The money will accumulate interest at 4% nominal annual, compounded quarterly. Which plan will have more money after 10 years? (6 marks)

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!