Use Excel.. (PV, FV, or PMT)

The table below represents the annual earnings from Tina's Trading Company, a mid-size manufacturing company. Annual earnings are reinvested into an account which earn 9.7% interest annually. What is the company's retained earnings account at the end of the last period? Net CF FV Year 2012 2013 2014 2015 2016 2017 2018 $ $ $ $ $ $ $ Income Expense 350,000.00 $ 155,000.00 413,678.00 $ 118,745.00 202,341.00 $ 121,713.63 213,469.76 $ 124,756.47 225,210.59 $ 127,875.38 237,597.17 $ 131,072.26 250,665.02 $ 134,349.07 8a) X= Tina's Trading Company round 2, with annual earnings reivested into an account which earned 9.7% interest annually. However, in 2014 Tina has a lawsuit for negligence to report failing parts and loses $500,000 as an expense. How much money (X) is in the company's retained earnings account at the end of the last period? (Hint: setup a table similar to 8a) 8b) 8b) | Xe