Question: Im trying to make sure that I input these transactions into the excel sheet properly. Could someone double check my work and tell me what

Im trying to make sure that I input these transactions into the excel sheet properly. Could someone double check my work and tell me what ones I got wrong and why they are wrong, so that I may find the right answer. 1. Acquired cash of $265,000 from the issue of common stock. 2. Borrowed $135,000 cash from the bank on April 1, 2018. 3. Paid $300,000 cash to purchase fixed assets - land that cost $70,000 and a building that cost $230,000. 4. Earned and recognized consulting revenue on account for $315,000 5. Collected $250,000 on the accounts receivable during the year 6. Incurred $175,000 of consulting expenses on account during the year. 7. Paid $130,000 on the accounts payable during the year. 8. Paid $97,500 cash for other operating expenses during the year. 9. Paid the company owners $6,300 of dividends. 10. Received $28,500 cash for services to be performed in the future.11. On June 1, paid $8,640 cash in advance for a one-year lease to rent office space. 12. Paid $10,050 cash for salaries expense. I know something is wrong as the assets don't = the liabilities+stock holders equity, Ive already added the transaction adjustments as well, so I know that I have unfortunately put transactions in incorrectly. Thank you.

Im trying to make sure that I input these transactions into the

Student Horizontal Model Template - Excel Sydney Riddle - AutoSave on File Home 9 Insert .B: Draw Page Layout O X Comments Formulas Team Tell me what you want to do Share 10 A A Data Review View Help 2 Wrap Text Nurnber E Merge & Center - $ -% 21 EB:48 Paste LE Arial BIU - B Font A - Conditional Format as Formatting Table - Cell Styles - Insert Delete Format Sort & Find & Filter - Select - Clipboard Alignment Number Styles Cells Editing N28 Y Z AA AB AC AD AE AF AG Cash Flows 285 000 285 cool 136.000 (300 000! 315.000 200.000 315.000 230,000) 175.000 130,000) 21.500 28,500 (13.360: 11,500) 11.500 AME 10.125 27.410 50185 221.500 3.800 70.000 218,500 11500 11.30,000 1,145 15,150 10.125 135.000 25.000 27.410 | 315,000 175.000 97.500 Tip. Remember to impul expenses as positive numbers Total Assets Horizontal Model $ 583.965 Support Calculations Total Liabilities + Equity Income & Equity Statement $ 327.530 Balance sheet and Cash Fl... + Ready # -- - + 599 16 Type here to search o EL 6 9 * e xD A ll ( 9/26/20193

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Accounting Questions!