Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Please answer in excel and provide what is the cash account balance at the end of this three-month period? the expected answer should be $13575
Please answer in excel and provide what is the cash account balance at the end of this three-month period?
the expected answer should be $13575
1. Michele Brown started up a new consulting firm to offer design and testing services to industries. During the first three months of its operation, the firm has recorded a number of transactions, shown as follows: a. Michele Brown initiated the business by investing $35,000 in cash; $1,200 for office equipment; and $23,500 for instrumentation. b. Land for an office site was purchased for $17,500 : $5,000 paid in cash and a promissory note signed for the balance. c. A prefabricated building was purchased for $7000 cash and moved onto the land for use as an office. d. The premium of $800 was paid on an insurance policy. e. A consulting project for Central Construction was completed, and $900 was collected. f. Additional test equipment costing $10,000 was purchased for $2,000 in cash, and a note payable for the balance was signed. g. A consulting project was completed on credit for Eastern Manufacturing for $1200. h. Office supplies were purchased on credit for $300. i. A bill was received for $250 and recorded as an account payable for rent on a special machine used for the Western Technologies project. j. A project for Superior Design was completed on credit for $1000. k. Cash was received from Eastern Manufacturing for the consulting project they received on credit. 1. The wage of engineers, $5000, was paid. m. Office supplies purchased earlier (for \$300) were paid for. n. Cash of $125 was paid for repairs to test equipment. o. The company president, Larry Brown, wrote a $65 check on the bank account of the consulting firm to pay for repairs to his personal automobile, which is not used for business purposes. p. The wage of the office workers, $3000, was paid. q. The maintenance expenses of the instruments, $300, was paid. Open the following T-accounts: cash, accounts receivable, prepaid insurance, test equipment, building, land, notes payable, accounts payable, office supplies, Larry Brown-capital, Larry Brown-withdrawals, sales revenue, ancial Accounting and Management for Engineering Managers 247 instrument maintenance expense, test equipment rental expense, office equipment, instrumentation, and test equipment repairs. Record the transactions by entering debits and credits directly into the accounts. Use the transaction letters to identify each debit and credit entry. What is the cash account balance at the end of this three-month periodStep by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started