Question: please show the excel function in the yellow blank The table below represents the annual earnings from Tina's Trading Company. Annual earnings are deposited into

 please show the excel function in the yellow blank The table

please show the excel function in the yellow blank

The table below represents the annual earnings from Tina's Trading Company. Annual earnings are deposited into an account that pays 7.4% per year. How much money (X) is in the company's retained earnings account at the end of the last period? 8a) Net CF Year Income Expense 55,000.00 56,375.00 57,784.38 59,228.98 60,709.71 62,227 45 63,783.14 FV 100,000.00 $ 105,500.00 $ $ 2012 $ 2013 $ 111,302.50 S 2014 2015 $ 117,424.14 $ $ 2016 123,882.47 $ 130,696.00 $ $ 2017 $ 2018 137,884 28 $ 8a) X= Tina's Trading Company round 2, with annual earnings are deposited into an account that pays 7.4% per year. However, in 2014 Tina has a lawsuit with an injured employee and loses $200,000 as an expense. How much money (X) is in the company's retained earnings account at the end of the last period? Build the table and calculate the retained earnings like above 8b) Year Income Expense 55,000.00 56,375.00 111,302.50 $ 257,784.38 59,228.98 60,709.71 62,227.45 63,783.14 Net CF FV 100,000.00 S 105,500.00 $ 2012 $ 2013 $ 2014 $ 2015 $ 117,424.14 $ 2016 $ 123,882.47 $ 130,696.00 $ 137,884.28 $ 2017 $ 2018 $ 8b) X=

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!