The following spreadsheet shows financial data for Trance Electronics.Use the spreadsheet to answer the question(s)below.
-What is the cumulative net profit generated at the end of the first year?
A)$(153,894,400)
B)$1,270,950,988
C)$2,199,057,382
D)$(696,400,000)

Question

The following spreadsheet shows financial data for Trance Electronics.Use the spreadsheet to answer the question(s)below. 
-What is the cumulative net profit generated at the end of the first year?
A)$(153,894,400) 
B)$1,270,950,988 
C)$2,199,057,382 
D)$(696,400,000)

Quizplus · Accepted Answer

The cumulative net profit generated at the end of the first year can be calculated as the sum of the net profits for each quarter. Adding the net profits for quarters 1-4, the result is $(696,400,000), which is option D. There is no indication in the spreadsheet of the best choice(s) as that is subjective and depends on the company's goals and priorities.

The Following Spreadsheet Shows Financial Data for Trance Electronics