Assume the following beginning balance for Rustic Camp Sites as of January 1, 20xx: Cash - $51,000 Land - $500,000 Notes Payable - $400,000 Common Stock - $120,000 Retained Earnings - $31,000 Assume the following ending balance as of the end of the year Cash - $230,000 Land - $400,000 Notes Payable - $400,000 Common Stock - $152,000 Ending Retained Earnings - $78,000 Dividends - $9,000 Revenue - $116,000 Expense - $60,000 Construct an income statement, statement of changes in stockholders' equity and balance sheet as of the end of the year 20xx using the following Excel template: Chapter 1 Template Return to Week 1 Activities Please note that you should change the notifications under the "Setting" option so that you are notified when a grade is entered. Assignment Rubrics Criteria Ratings Pts The data was properly formatted. 2.0 pts Full Marks 0.0 pts No Marks 2.0 pts The formulas are well developed and will correctly determine the needed information. 8.0 pts 0.0 pts No Marks Full Marks 8.0 pts Total Points: 10.0 A B D E F G H 1 J K Rustic Camp Sites Income Statement For the Year Ended December 31, 20xx Rustic Camp Sites Balance Sheet December 31, 20xx Revenue Cash Expense Land Net Income Total Assets Notes Payable Rustic Camp Sites Statement of Changes in Stockholders Equity For the Year Ended December 31, 20xx Common Stock Retained Earnings Total Liabilities & S. Equity Beginning Common Stock Additional Common Stock Ending Common Stock Beginning Retained Earnings Net Income Less Dividends Ending Retained Earnings Total Stockholders Equity