please show the excel function in the yellow blank
Homework Answers
| Year | Income | Expense | Net CF | FV | Years to be metured |
| 2012 | $ 100,000.00 | $ 55,000.00 | $ 45,000.00 | $69,061.85 | 6 |
| 2013 | $ 105,500.00 | $ 56,375.00 | $ 49,125.00 | $70,197.88 | 5 |
| 2014 | $ 111,302.50 | $ 57,784.38 | $ 53,518.12 | $71,206.23 | 4 |
| 2015 | $ 117,424.14 | $ 59,228.98 | $ 58,195.16 | $72,094.10 | 3 |
| 2016 | $ 123,882.47 | $ 60,709.71 | $ 63,172.76 | $72,868.26 | 2 |
| 2017 | $ 130,696.00 | $ 62,227.45 | $ 68,468.55 | $73,535.22 | 1 |
| 2018 | $ 137,884.28 | $ 63,783.14 | $ 74,101.14 | $74,101.14 | 0 |
| Total | $ 826,689.39 | $ 415,108.66 | $ 411,580.73 | $503,064.67 | |
| 8(a) X= | $503,064.67 | ||||
| Explanation | |||||
|
excel formula for net Cf=Income-Expenses) excel formula for X=sum(FV of all years) |
|||||
| excel formula for net FV=FV (rate, nper, pmt, [pv], [type]) | |||||
| for 2012, FV=FV(7.04%,6,0,-45000) | |||||
| Year | Income | Expense | Net CF | FV | Years to be metured |
| 2012 | $ 100,000.00 | $ 55,000.00 | $ 45,000.00 | $69,061.85 | 6 |
| 2013 | $ 105,500.00 | $ 56,375.00 | $ 49,125.00 | $70,197.88 | 5 |
| 2014 | $ 111,302.50 | $ 257,784.38 | $ (146,481.88) | ($194,895.15) | 4 |
| 2015 | $ 117,424.14 | $ 59,228.98 | $ 58,195.16 | $72,094.10 | 3 |
| 2016 | $ 123,882.47 | $ 60,709.71 | $ 63,172.76 | $72,868.26 | 2 |
| 2017 | $ 130,696.00 | $ 62,227.45 | $ 68,468.55 | $73,535.22 | 1 |
| 2018 | $ 137,884.28 | $ 63,783.14 | $ 74,101.14 | $74,101.14 | 0 |
| Total | $ 826,689.39 | $ 615,108.66 | $ 211,580.73 | $236,963.30 | |
| 8(b) X= | $236,963.30 | ||||
Add Answer to:
please show the excel function in the yellow blank
The table below represents the annual earnings...
Use Excel.. (PV, FV, or PMT) The table below represents the annual earnings from Tina's Trading...
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...
Check my work Exercise 3-15A Calculate the balance of retained earnings (LO3-5) Below are the restated...
Check my work Exercise 3-15A Calculate the balance of retained earnings (LO3-5) Below are the restated amounts of net income and retained earnings for Volunteers Inc. and Raiders Inc. for the period 2012-2021. Volunteers began operations in 2013, while Raiders began several years earlier. Required: Calculate the balance of retained earnings each year for each company. Neither company paid dividends during this time. (Enter your answers in millions (i.e., 10,000,000 should be entered as 10). Amounts to be deducted should...
Below are the restated amounts of net income and retained earnings for Volunteers Inc. and Raiders...
Below are the restated amounts of net income and retained earnings for Volunteers Inc. and Raiders Inc. for the period 2009-2018. Volunteers began operations in 2010, while Raiders began several years earlier Required Calculate the balance of retained earnings each year for each company. Neither company paid dividends during this time. (Enter your answers in millions (i.e., 10,000,000 should be entered as 10).) VOLUNTEERS INC. RAIDERS INC (S in millions) Net (S in millions) Retained Net Retained Year Income (Loss)...
Below are the restated amounts of net income and retained earnings for Volunteers Inc. and Raiders...
Below are the restated amounts of net income and retained
earnings for Volunteers Inc. and Raiders Inc. for the period
2012–2021. Volunteers began operations in 2013, while Raiders began
several years earlier.
Required:
Calculate the balance of retained earnings each year for each
company. Neither company paid dividends during this time.
please help me with my homework.
Required: Calculate the balance of retained earnings each year for each company. Neither company paid dividends during this time. (Enter your answers...
Below are the restated amounts of net income and retained earnings for Volunteers Inc and Raiders...
Below are the restated amounts of net income and retained
earnings for Volunteers Inc and Raiders for the period 2012-2021
Volunteers began operations in 2013, while Raiders began several
years earlier Required : Calculate the balance of retained earnings
each year for each companyNeither company paid dividends during
this time. (Enter your answers in millions (ie10,000,000 should be
entered 10). Amounts to be deducted should be indicated by minus
sign.)
Below are the restated amounts of net income and retained...
Below are the restated amounts of net income and retained earnings for Volunteers Inc. and Raiders...
Below are the restated amounts of net income and retained earnings for Volunteers Inc. and Raiders Inc. for the period 2009-2018. Volunteers began operations in 2010, while Raiders began several years earlier. Required: Calculate the balance of retained earnings each year for each company. Neither company paid dividends during this time. (Enter your answers in millions (i.e., 10,000,000 should be entered as 10).) Year 2009 VOLUNTEERS INC. RAIDERS INC. ($ in millions) ($ in millions) Net Retained Net Retained Income...
meWUIR Cldple 3 Below are the restated amounts of net income and retained earnings for Volunteers...
meWUIR Cldple 3 Below are the restated amounts of net income and retained earnings for Volunteers Inc. and Raiders Inc. for the period 2009-2018 Volunteers began operations in 2010, while Raiders began several years earlier. Required: Calculate the balance of retained earnings each year for each company. Neither company paid dividends during this time. (Enter your answers in millions (i.e., 10,000,000 should be entered as 10).) VOLUNTEERS INC. RAIDERS INC. (5 in millions) (S in millions) Net Retained Net Retained...
Analysis and Correction of Errors ACPA was engaged by Blackbird Company in 2015 to examine its...
Analysis and Correction of Errors ACPA was engaged by Blackbird Company in 2015 to examine its books and records and to make whatever corrections are necessary. An examination of the accounts discloses the following. (a) Dividends had been declared on December 15 in 2012 and 2013 but had not been entered in the books until paid. (b) Improvements in buildings and equipment of $10,800 had been debited to expense at the end of April 2011. Improvements are estimated to have...
b. The Table below provides the annual rainfall records at gages A, B, C, D and...
b. The Table below provides the annual rainfall records at gages A, B, C, D and X. The records of A, B, C and D are consistent. Gage X was temporarily relocated in January 2012 and was returned to the original station in January 2016. Adjust the 2012 to 2015 records of X, and determine the adjusted average annual rainfall at the X gage for the period 2006-2015. YEAR PRECIPITATION, cm A B с D X 2006 2007 2008 2009...
Please show me the excel work if possible. thank you Data Table Barron Pizza, Inc. Abbreviated...
Please show me the excel work
if possible. thank you
Data Table Barron Pizza, Inc. Abbreviated Income Statements for the Years Ending 2012-2014 ($ in thousands, except earnings per share) Year Ending Year Ending Year Ending Account 2014 2013 2012 Revenue $ 917,227 $ 946,228 Cost of goods sold $ -669,249 $ -656,300 Gross profit $ 169,391 314,926 Selling, general, and administrative expenses -70,527 -193,048 Research and development $ 5,379 S -7,021 S -3,518 Depreciation $ -34,475 $ -35,760 Operating...
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...
Check my work Exercise 3-15A Calculate the balance of retained earnings (LO3-5) Below are the restated amounts of net income and retained earnings for Volunteers Inc. and Raiders Inc. for the period 2012-2021. Volunteers began operations in 2013, while Raiders began several years earlier. Required: Calculate the balance of retained earnings each year for each company. Neither company paid dividends during this time. (Enter your answers in millions (i.e., 10,000,000 should be entered as 10). Amounts to be deducted should...
Below are the restated amounts of net income and retained earnings for Volunteers Inc. and Raiders Inc. for the period 2009-2018. Volunteers began operations in 2010, while Raiders began several years earlier Required Calculate the balance of retained earnings each year for each company. Neither company paid dividends during this time. (Enter your answers in millions (i.e., 10,000,000 should be entered as 10).) VOLUNTEERS INC. RAIDERS INC (S in millions) Net (S in millions) Retained Net Retained Year Income (Loss)...
Below are the restated amounts of net income and retained
earnings for Volunteers Inc. and Raiders Inc. for the period
2012–2021. Volunteers began operations in 2013, while Raiders began
several years earlier.
Required:
Calculate the balance of retained earnings each year for each
company. Neither company paid dividends during this time.
please help me with my homework.
Required: Calculate the balance of retained earnings each year for each company. Neither company paid dividends during this time. (Enter your answers...
Below are the restated amounts of net income and retained
earnings for Volunteers Inc and Raiders for the period 2012-2021
Volunteers began operations in 2013, while Raiders began several
years earlier Required : Calculate the balance of retained earnings
each year for each companyNeither company paid dividends during
this time. (Enter your answers in millions (ie10,000,000 should be
entered 10). Amounts to be deducted should be indicated by minus
sign.)
Below are the restated amounts of net income and retained...
Below are the restated amounts of net income and retained earnings for Volunteers Inc. and Raiders Inc. for the period 2009-2018. Volunteers began operations in 2010, while Raiders began several years earlier. Required: Calculate the balance of retained earnings each year for each company. Neither company paid dividends during this time. (Enter your answers in millions (i.e., 10,000,000 should be entered as 10).) Year 2009 VOLUNTEERS INC. RAIDERS INC. ($ in millions) ($ in millions) Net Retained Net Retained Income...
meWUIR Cldple 3 Below are the restated amounts of net income and retained earnings for Volunteers Inc. and Raiders Inc. for the period 2009-2018 Volunteers began operations in 2010, while Raiders began several years earlier. Required: Calculate the balance of retained earnings each year for each company. Neither company paid dividends during this time. (Enter your answers in millions (i.e., 10,000,000 should be entered as 10).) VOLUNTEERS INC. RAIDERS INC. (5 in millions) (S in millions) Net Retained Net Retained...
Analysis and Correction of Errors ACPA was engaged by Blackbird Company in 2015 to examine its books and records and to make whatever corrections are necessary. An examination of the accounts discloses the following. (a) Dividends had been declared on December 15 in 2012 and 2013 but had not been entered in the books until paid. (b) Improvements in buildings and equipment of $10,800 had been debited to expense at the end of April 2011. Improvements are estimated to have...
b. The Table below provides the annual rainfall records at gages A, B, C, D and X. The records of A, B, C and D are consistent. Gage X was temporarily relocated in January 2012 and was returned to the original station in January 2016. Adjust the 2012 to 2015 records of X, and determine the adjusted average annual rainfall at the X gage for the period 2006-2015. YEAR PRECIPITATION, cm A B с D X 2006 2007 2008 2009...
Please show me the excel work
if possible. thank you
Data Table Barron Pizza, Inc. Abbreviated Income Statements for the Years Ending 2012-2014 ($ in thousands, except earnings per share) Year Ending Year Ending Year Ending Account 2014 2013 2012 Revenue $ 917,227 $ 946,228 Cost of goods sold $ -669,249 $ -656,300 Gross profit $ 169,391 314,926 Selling, general, and administrative expenses -70,527 -193,048 Research and development $ 5,379 S -7,021 S -3,518 Depreciation $ -34,475 $ -35,760 Operating...
Most questions answered within 3 hours.
-
Where is the error in this code sequence?
String s1 = "Hello";
String s2 = "ello";...
asked 10 months ago -
Financial data for Joel de Paris, Inc., for last year
follow:
Joel de Paris, Inc.
Balance...
asked 10 months ago -
Consider this reaction:
Al2(SO4)3 (aq)+ BaCl3
(aq) Al2Cl6 (aq)- +
3BaSO4(s) . What is the...
asked 10 months ago -
Suppose that Savneet is considering increasing her
recent random sample from 20 car rentals to 40...
asked 10 months ago -
Trucks arrive at an unloading terminal at an average rate of 120
per hour.
Trucks arrive...
asked 10 months ago -
Why are methanol and ethanol completely soluble in water while
octanol is not very little soluble....
asked 10 months ago -
A facilities manager at a university reads in a research report
that the mean amount of...
asked 10 months ago -
When the CuSO4 is rehydrated by adding water to the anhydrous
compound, is this an endothermic...
asked 10 months ago -
A ray of sunlight is passing from diamond into crown glass; the
angle of incidence is...
asked 10 months ago -
A block of mass 0.249 kg is placed on top of a light, vertical
spring of...
asked 10 months ago -
how do the kidneys compensate in the presences of acidosis
a) trigger hyperventilate
b) reserve acid...
asked 10 months ago -
Question 501 pts
The rental rate of capital to the firm increases. Which of the
following...
asked 10 months ago