Question

Can someone please show me the proper way to set up this spreadsheet

Given the following information, prepare an income statement and statement of retained earnings to solve the unknown (a, b, c)

Paid-in-Capital, beginning of period $1,700 Paid-in Capital, end of period c Ratained earnings, beginning of period b Retained earnings, end of period $2,300 Revenues $2,800 Cost and expenses a Net Income $1,300 Dividends $400 Additional Investments by stockholders $100

Answer 1

a.	Cost and expenses	=	$                                                   1,500
	Net Income	=	Revenues	-	Cost and expenses
	$                                                      1,300	=	$                                                   2,800	-	Cost and expenses
	Cost and expenses	=	$2800 - $1300
	Cost and expenses	=	$                                                   1,500
b.	Retained earnings beginning of the period	=	$                                                   1,400
	Retained earnings end of the period	=	Retained earnings beginning of the period	+	Net Income	-	Dividends
	$                                                      2,300	=	Retained earnings beginning of the period	+	$                         1,300	-	$          400
	Retained earnings beginning of the period	=	$2300 - $1300 + $400
		=	$                                                   1,400
c.	Paid - in capital end of the period	=	$                                                   1,800
	Paid - in capital end of the period	=	Paid - in capital beginning of the period	+	Additional Investments by stockholder's
		=	$                                                   1,700	+	$                             100
		=	$                                                   1,800