Question

2 of 8 (1 complete) Score: 0 of 1 pt E3-20 (book/static) HW Score: 9.38%, 0.75 of 8 pts E Question Help O Consider the facts presented in the following table for Tropical View. (Click the icon to view the table.) Complete the table by filling in the missing values. Situation Data Table 1,400 700 Beginning Prepaid Rent Payments for Prepaid Rent during the year Total amount to account for Subtract: Ending Prepaid Rent Rent Expense 2,100 300 Situation А в со 1.400 $ 1,000 $ 200 S 700 700 1,800 1 Beginning Prepaid Rent $ c Payments for Prepaid Rent during the year Total amount to account for Subtract: Ending Prepaid Rent Rent Expense 2,100 800 1,800c 700 600 $ $ $ 900 $ 1,900 S 1,000 Print Done

Answer 1

Beginning Rent + Received = Total amount

Total amount - Ending prepaid rent = Rent Expense

	A	B	C	D
Beginning Prepaid Rent	1,400	1,000	200	700
Payments for Prepaid rent	700	600	1,800	900
Total Amount to account for	2,100	1,600	2,000	1,600
Subtract: Ending Prepaid Rent	800	700	100	600
Rent Expense	1,300	900	1,900	1,000

1 B C D E BCD 2 Beginning Prepaid Rent 1400 1000 200 700 3 Payments for Prepaid rent 700 =C4-C2 1800 =E4-E2 4 Total Amount to account for =SUM(B2:B3) 1600 =SUM(D2:D3) =E5+E6 5 Subtract: Ending Prepaid Rent 800 700 =D4-D6 600 6 Rent Expense =B4-B5 =C4-C5 1900 1000