If GreenWave Technologies decides to invest an additional $50,000 in equipment, how should you update the spreadsheet to calculate the new net worth? Assume total assets are in cell B1, total liabilities are in cell B2, and net worth is calculated in cell B3.
Answer
A
update B1 to is equal to 500 comma 000 plus 50 comma 000, B2 to is equal to 200 comma 000 plus 50 comma 000, B3 formula remains is equal to cap b 1 minus cap b 2
B
update B1 to is equal to 500 comma 000 plus 50 comma 000, B2 remains the same, B3 formula remains is equal to cap b 1 minus cap b 2
C
update B2 to is equal to 500 comma 000 minus 50 comma 000, B1 remains the same, B3 formula remains is equal to cap b 1 minus cap b 2
D
update B1 to is equal to 500 comma 000 minus 50 comma 000, B2 remains the same, B3 formula remains is equal to cap b 1 minus cap b 2
Explanation
Buying equipment for an additional $50,000 increases total assets by $50,000, while liabilities do not change just because the company made the investment. Update B1 from $500,000 to $550,000, leave B2 unchanged, and keep B3 calculating net worth as =B1-B2. This matches choice C.
AI-written and checked against the verified answer.