a) | ||||
Year | Income | Expense | Net CF | FV |
2012 | $ 350,000.00 | $ 155,000.00 | $ 195,000.00 | $339,839.91 |
2013 | $ 413,678.00 | $ 118,745.00 | $ 294,933.00 | $468,550.61 |
2014 | $ 202,341.00 | $ 121,713.63 | $ 80,627.37 | $116,764.01 |
2015 | $ 213,469.76 | $ 124,756.47 | $ 88,713.29 | $117,113.93 |
2016 | $ 225,210.59 | $ 127,875.38 | $ 97,335.21 | $117,134.07 |
2017 | $ 237,597.17 | $ 131,072.26 | $ 106,524.91 | $116,857.83 |
2018 | $ 250,665.02 | $ 134,349.07 | $ 116,315.95 | $ 116,315.95 |
X = | $1,392,576.30 | |||
b) | ||||
Year | Income | Expense | Net CF | FV |
2012 | $ 350,000.00 | $ 155,000.00 | $ 195,000.00 | $339,839.91 |
2013 | $ 413,678.00 | $ 118,745.00 | $ 294,933.00 | $468,550.61 |
2014 | $ 202,341.00 | $ 621,713.63 | $ (419,372.63) | ($607,332.60) |
2015 | $ 213,469.76 | $ 124,756.47 | $ 88,713.29 | $117,113.93 |
2016 | $ 225,210.59 | $ 127,875.38 | $ 97,335.21 | $117,134.07 |
2017 | $ 237,597.17 | $ 131,072.26 | $ 106,524.91 | $116,857.83 |
2018 | $ 250,665.02 | $ 134,349.07 | $ 116,315.95 | $ 116,315.95 |
X = | $668,479.69 |
Use Excel.. (PV, FV, or PMT) The table below represents the annual earnings from Tina's Trading...
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...
[The following information applies to the questions displayed below.] On December 1, Year 1, John and Patty Driver formed a corporation called Susquehanna Equipment Rentals. The new corporation was able to begin operations immediately by purchasing the assets and taking over the location of Rent-It, an equipment rental company that was going out of business. The newly formed company uses the following accounts. Cash Capital Stock Accounts Receivable Retained Earnings Prepaid Rent Dividends Unexpired Insurance Income Summary Office Supplies Rental...
[The following information applies to the questions displayed below.] On December 1, Year 1, John and Patty Driver formed a corporation called Susquehanna Equipment Rentals. The new corporation was able to begin operations immediately by purchasing the assets and taking over the location of Rent-It, an equipment rental company that was going out of business. The newly formed company uses the following accounts. Cash Capital Stock Accounts Receivable Retained Earnings Prepaid Rent Dividends Unexpired Insurance Income Summary Office Supplies Rental...
Cash Capital Stock Accounts Receivable Retained Earnings Prepaid Rent Dividends Unexpired Insurance Income Summary Office Supplies Rental Fees Earned Rental Equipment Salaries Expense Accumulated Depreciation: Rental Equipment Maintenance Expense Notes Payable Utilities Expense Accounts Payable Rent Expense Interest Payable Office Supplies Expense Salaries Payable Depreciation Expense Dividends Payable Interest Expense Unearned Rental Fees Income Taxes Expense Income Taxes Payable The corporation performs adjusting entries monthly. Closing entries are performed annually on December 31. During December, the corporation entered into the...
Required information Comprehensive Problem 1 [The following information applies to the questions displayed below.] On December 1, Year 1, John and Patty Driver formed a corporation called Susquehanna Equipment Rentals. The new corporation was able to begin operations immediately by purchasing the assets and taking over the location of Rent-It, an equipment rental company that was going out of business. The newly formed company uses the following accounts. Cash Capital Stock Accounts Receivable Retained Earnings Prepaid Rent Dividends Unexpired Insurance...
Required Information The following information applies to the questions displayed below.) On December 1 Year 1, John and Patty Driver formed a corporation called Susquehanna Equipment Rentals. The new corporation was able to begin operations immediately by purchasing the assets and taking over the location of Rent-it, an equipment rental company that was going out of business. The newly formed company uses the following accounts Cash Accounts Receivable Prepaid Rent Unexpired Insurance Office Supplies Rental Equipment Accumulated Depreciation: Rental Equipment...
[The following information applies to the questions displayed below.] On December 1, Year 1, John and Patty Driver formed a corporation called Susquehanna Equipment Rentals. The new corporation was able to begin operations immediately by purchasing the assets and taking over the location of Rent-It, an equipment rental company that was going out of business. The newly formed company uses the following accounts. Cash Capital Stock Accounts Receivable Retained Earnings Prepaid Rent Dividends Unexpired Insurance Income Summary Office Supplies Rental...
[The following information applies to the questions displayed below.] On December 1, Year 1, John and Patty Driver formed a corporation called Susquehanna Equipment Rentals. The new corporation was able to begin operations immediately by purchasing the assets and taking over the location of Rent-It, an equipment rental company that was going out of business. The newly formed company uses the following accounts. Cash Capital Stock Accounts Receivable Retained Earnings Prepaid Rent Dividends Unexpired Insurance Income Summary Office Supplies Rental...
Required information [The following information applies to the questions displayed below.] On December 1, Year 1, John and Patty Driver formed a corporation called Susquehanna Equipment Rentals. The new corporation was able to begin operations immediately by purchasing the assets and taking over the location of Rent-It, an equipment rental company that was going out of business. The newly formed company uses the following accounts. Cash Capital Stock Accounts Receivable Retained Earnings Prepaid Rent Dividends Unexpired Insurance Income Summary Office...
Required information Comprehensive Problem 1 [The following information applies to the questions displayed below.] On December 1, Year 1, John and Patty Driver formed a corporation called Susquehanna Equipment Rentals. The new corporation was able to begin operations immediately by purchasing the assets and taking over the location of Rent-It, an equipment rental company that was going out of business. The newly formed company uses the following accounts. Cash Capital Stock Accounts Receivable Retained Earnings Prepaid Rent Dividends Unexpired Insurance...