Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Please show how the excel is suppose to look like on a table then please provide a table with the EXACT formulas needed so I

Please show how the excel is suppose to look like on a table then please provide a table with the EXACT formulas needed so I can reference when completing this , I am a first year accounting student who is not familiar with excel , i need step by step direction on how to complete this for example (in cell a1, enter this formula (then what ever formula it is) ,I need this for the T Accounts as as well as the trial balance ,income statement ,statement of equity and the balance sheet ,do not explain just in words ,show the table with the numbers and show a table with the formulas (once again I HAVE NEVER USED EXCEL BEFORE) thanks in advance ,doing this will be such a major help

image text in transcribed

153 154 155 a. 156 b. 157 C. 158 d. 159 e. 160 f. 161 g h. 162 163 1. 164 165 166 167 27 168 169 28 170 171 29 172 173 30 174 175 31 176 177 178 130 November transactions for Camindo Co. are as follows Received cash of $60,000 from investors in exchange for common stock. Provided services of $16,300 on account. Purchased supplies on account $750. Received cash of $11,800 from clients for services previously billed. Received $6,250 in cash for services provided for clients Paid $600 on account for supplies that had been purchased. Paid cash $3,380 for a one-year insurance policy. Paid for the following expenses in cash: wages, $7,800; utilities, $1,000; rent, $3,750. Paid cash dividends of $2,300 to stockholders. Prepare Journal Entries for items above Post the transactions in question 26 to T Accounts Prepare Trial Balance from balances in T Accounts Prepare Income Statement from Trial Balance Prepare Statement of Equity from Trial Balance and Income Statement Prepare Balance Sheet

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Accounting What the Numbers Mean

Authors: David H. Marshall, Wayne W. McManus, Daniel F. Viele,

9th Edition

978-0-07-76261, 0-07-762611-7, 9780078025297, 978-0073527062

More Books

Students also viewed these Accounting questions

Question

1. Speak privately if possible; dont threaten.

Answered: 1 week ago