Lucky Medicals | ||||||||
Transaction for December | ||||||||
Transaction Description | Cash ($) | Accounts Receivable ($) | Supplies ($) | = | Accounts Payable ($) | Capital ($) | (+) Revenue ($) | (-) Expenses ($) |
a) beginning balance | 14500 | 2200 | 200 | = | 3000 | 13900 | ||
b) purchased supplies on account | 1100 | = | 1100 | |||||
c) billed customer for service to be paid next month | 6000 | = | 6000 | |||||
d) payment to creditor | -1500 | = | -1500 | |||||
e) owner's withdrawal | -3000 | = | -3000 | |||||
f) received cash from customer billed in transaction c | 3000 | -3000 | = | |||||
g) rent expense paid | -2000 | = | -2000 | |||||
h) wages paid | -1650 | = | -1650 | |||||
i) uitility bill paid | -350 | = | -350 | |||||
total balance | 9000 | 5200 | 1300 | = | 2600 | 10900 | 6000 | -4000 |
income statement
Lucky Medicals | |
Income Statement | |
For month ended Dec 31, xxxx | Amount ($) |
revenue | 6000 |
less:expenses | |
rent expense | -2000 |
wages paid | -1650 |
utility bills | -350 |
net income | 2000 |
owners equity
Lucky Medicals | |
Statement of owners equity | |
For month ended Dec 31, xxxx | Amount ($) |
beginning capital | 13900 |
add:net income | 2000 |
less:drawings | -3000 |
ending balance | 12900 |
balance sheet
Lucky Medicals | |||
Balance Sheet | |||
As of Dec 31,xxxx | |||
Assets | Amount ($) | Liabilities | Amount ($) |
cash | 9000 | accounts payable | 2600 |
accounts receivable | 5200 | owners equity | |
supplies | 1300 | ending capital | 12900 |
Total assets | 15500 | Total liabilities and equity | 15500 |
HW - Saved - X Samuel Agada Help Tell me 0 Share File Home Insert Draw...
ch1 Excel ka ta ki DD File Home Insert Draw Page Layout Formulas Data ReviewView Help Tell me what you want to do 凸Share Commen Conditional Format as Cell Insert Delete Format FormattingTable- Styles Merge & Center iter Select Styles G25 1 Echo Lake Corporation 2 Transaction Analysis INFORMATION Echo Lake Corporation started operations on November 1, 2018. The nine transactions that occurred during November appear below Requirements 1. Use Excel to prepare a transaction analysis of the nine transactions....
? X SSB HOME INSERT Preparing a classified balance sheet - Excel FORMULAS DATA REVIEW - Sign In PAGE LAYOUT VIEW Paste B I U. . Clipboard Font - A - Alignment Number Conditional Format as Cell Cells Formatting Table Styles - Styles fic The following transactions occurred for Lantana Company during its first month A1 X H The following transactions occurred for Lantana Company during its first month of operations and have been recorded in the T-accounts below. 4...
X AutoSave 6 2 Project 1 Basic Excel Wilhelm 520 2.1 Saved - File Home Insert Draw - Page Layout Formulas Data Review View Help Liberation Sans - 12 AA 2 Number Paste BIU A 2 $ -% 9 438-68 Conditio Formatt Clipboard Font Alignment Number E36 - X f Value AB 1 E4-14 Analyze adiusted data 2 This is a partial adjusted trial balance of Ramon Company RAMON COMPANY Adjusted Trial Balance January 31, 2017 Credit Supplies Prepaid Insurance...
stuck , help me out please Financial Statements Your Company Income Statement For the Year Ended December 31, 2015 Fees Earned Expenses Your Company Balance Sheet December 31, 2015 ASSETS Current Assets Total Expenses Net Income Total Current Assets Property, plant and equipment Your Company Statement of Owners' Equity For the Year Ended December 31, 2015 Total Property, Plant & Equipment Total Assets LIABILITIES & OWNERS EQUITY Current Liabilities Beginning Capital Net Income for the year Less withdrawals Increase in...
use cell references for answers MINH PHUN FE HOME Sign in 37 Calibri B I INSERT PAGE LAYOUT FORMULAS DATA REVIEW VIEW 11 AA = F ) . B. . A Alignment Number Conditional Format as Cell Formatting Table Styles" Font Styles V Cells ints Editing Paste Clipboard Skipped The following transactions occurred for Lantana Company during its first month H eBook DEF 1 The following transactions occurred for Lantana Company during its first month of operations 2 and have...
X! Preparing a classified balance sheet - Excel х FILE HOME INSERT PAGE LAYOUT FORMULAS DATA REVIEW VIEW Sign In Calibri 11 Α Α΄ % Paste BIU- Alignment Number Cells Conditional Format as Cell Formatting Table Styles Styles Clipboard Font 1 : A B с I 37 38 D E F G H LANTANA COMPANY Balance Sheet At December 31, 2016 Liabilities and Stockholders' Equity Current Liabilities 39 40 Assets 41 Current Assets 42 Total Current Liabilities 43 44 Total...
File Home Insert Draw Page Layout Formulas Data Review View Help Power Pivot X Calibri 29 General 11 - A Ă B I J - - - - - - Paste ======= B $ % 948 - Conditional Format as "Cell Formatting Table Styles Clipboard Font Alignment Number Styles A16 fr А B С D E G H K M 7 8 9 Gross patient service revenue (total charges) $975,000 Contractual discounts and allowances to third-party payers 250,000 10 Charges...
MUST SHOW ALL CORRECT EXCEL FORMULAS 5 X FILE HOME INSERT X Arial Amortization with equal payments - Excel PAGE LAYOUT FORMULAS DATA REVIEW VIEW Sign In 12 - A A % Alignment Number Conditional Format as Cell Cells Editing Formatting Table Styles Styles fx Prepare an amortization schedule for a five-year loan of $67,500. The interest Paste B 1 U Clipboard Font C3 HE с D E G H 1 2 2 3 Prepare an amortization schedule for a...
? - 6 X Sign In KD 9.. Preparing a classified balance sheet - Excel FILE HOME INSERT PAGE LAYOUT FORMULAS DATA REVIEW VIEW Calibri - 11AA = % D D BIU- B A Alignment Number Conditional Format as Cell Formatting Table Styles Clipboard Styles Paste Cells - Editing Font A1 The following transactions occurred for Lantana Company during its first month DEF 4 . Received $50.000 cash from owners in exchange for common stock 5 6. Purchased land for...
Adekunle John AutoSave CH H File Home Insert - 0 x Comments Share U Draw Design Layout References Mailings Times New Roman .14 . A A Aa AO BIU.ab X, X ADA Review E C Xcut View Help Grammarly Search EE211 AaBbc AalbCol AaBb C AaBbccc AaB 1 . . 1 Normal 1 No Spac... Heading 1 Heading 2 Title Find - Replace Select Paste Dictate Lith copy Format Painter Clipboard - Open Grammarly Font Paragraph Styles Editing Voice Grammarly...