ACCT 203 Lecture Notes - Lecture 5: Historical Cost, Accounts Payable
Get access
Related Documents
Related Questions
I have done all the adjusting entries and was wondering ifsomeone could take a look at them. I would really appreciate it ifyou could give me some feedback if any are wrong and how to fixthem. Two that I am real unsure about are "b." and "q." but againif you could look at them all I would be very grateful. ThankYou
DeeDee DoubleEntry, Incorporated | ||||||
End of Period Worksheet | ||||||
For the Year Ended December31, 2017 | ||||||
Unadjusted | Adjusted | |||||
Account Title | Trial Balance | Adjustments | Trial Balance | |||
DR | CR | DR | CR | DR | CR | |
Cash | 240,300 | - | 27,000 | 213,300 | ||
Restricted Cash | 27,000 | 27,000 | ||||
Accounts Receivable | 925,000 | - | 925,000 | |||
Allowance for Doubtful Accounts | - | 49,000 | 67,000 | 18,000 | ||
Interest Receivable | - | 688 | 688 | |||
Merchandise Inventory | 187,500 | - | 3,700 | 191,200 | ||
Prepaid Insurance | 9,000 | - | 5,211 | 3,789 | ||
Prepaid Advertising | - | - | 12,000 | 12,000 | ||
Prepaid Rent | - | - | 7,500 | 7,500 | ||
Office Supplies | 7,800 | - | 2,941 | 4,859 | ||
Note Receivable | 75,000 | - | 75,000 | |||
Available for Sale Securities | 380,000 | - | 380,000 | |||
Office Building | 4,250,000 | - | 4,250,000 | |||
Accumulated Depreciation - OfficeBuilding | - | 221,500 | 38,750 | 260,250 | ||
Storage Building | 1,650,000 | - | 1,650,000 | |||
Accumulated Depreciation - StorageBuilding | - | - | 46,667 | 46,667 | ||
Land | 450,000 | - | 450,000 | |||
Leasehold Improvements | 190,000 | - | 5,459 | 195,459 | ||
Accumulated Depreciation - LeaseholdImprovements | - | - | 728 | 728 | ||
Office Equipment | 125,000 | - | 125,000 | |||
Accumulated Depreciation - OfficeEquipment | - | 42,000 | 16,600 | 58,600 | ||
Patent | 250,000 | - | 250,000 | |||
Accumulated Amortization | 31,250 | 31,250 | ||||
Accounts Payable | - | 145,000 | 145,000 | |||
Sales Tax Payable | - | - | 19,821 | 19,821 | ||
Salaries Payable | - | - | 39,249 | 39,249 | ||
Payroll Taxes Payable | - | - | 3,251 | 3,251 | ||
Interest Payable | - | - | 127,750 | 127,750 | ||
Income Tax Payable | - | - | 245,756 | 245,756 | ||
Unearned Rent Revenue | - | 96,000 | 25,263 | 70,737 | ||
Loan Payable - Onstar Bank | - | 500,000 | 500,000 | |||
Loan Payable - Coldstar Bank | - | 2,250,000 | 2,250,000 | |||
Common Stock | - | 425,000 | 425,000 | |||
Additional Paid in Capital | - | 2,800,000 | 2,800,000 | |||
Retained Earnings | - | 1,379,420 | 1,379,420 | |||
Accumulated Other ComprehensiveIncome | - | 8,500 | 8,500 | |||
Dividends | 280,000 | - | 280,000 | |||
Sales | - | 4,380,250 | 19,821 | 4,360,429 | ||
Sales Returns and Allowances | 19,500 | - | 19,500 | |||
Sales Discounts | 14,600 | - | 14,600 | |||
Cost of Goods Sold | 1,817,900 | - | 3,700 | 1,814,200 | ||
Amortization Expense | 31,250 | 31,250 | ||||
Sales Salaries Expense | 676,400 | - | 25,500 | 701,900 | ||
Office Salaries Expense | 434,000 | - | 17,000 | 451,000 | ||
Advertising Expense | 54,000 | - | 12,000 | 42,000 | ||
Depreciation Expense - OfficeBuilding | - | - | 38,750 | 38,750 | ||
Depreciation Expense - StorageBuilding | 46,667 | 46,667 | ||||
Depreciation Expense - LeaseholdImprovements | - | - | 728 | 728 | ||
Depreciation Expense - OfficeEquipment | - | - | 16,600 | 16,600 | ||
Leasing Expense - Stores | 132,000 | - | 132,000 | |||
Miscellaneous Selling Expense | 16,950 | - | 5,459 | 11,491 | ||
Rent Expense - Storage Facility | 18,000 | - | 7,500 | 10,500 | ||
Insurance Expense | 2,000 | - | 5,211 | 7,211 | ||
Office Supplies Expense | 28,500 | - | 2,941 | 31,441 | ||
Warranty Expense | 5,000 | 5,709 | 10,709 | |||
Miscellaneous Administrative Expense | 9,220 | - | 9,220 | |||
Rent Revenue | - | - | 25,263 | 25,263 | ||
Interest Revenue on Note Receivable | - | - | 688 | 688 | ||
Dividend Revenue on AFS Securities | - | 18,000 | 18,000 | |||
Warranty Liability | 5,709 | 5,709 | ||||
Income Tax Expense | 245,756 | 245,756 | ||||
Interest Expense | 127,750 | 127,750 | ||||
Bad Debt Expense | 67,000 | - | 67,000 | |||
12,314,670 | 12,314,670 | 732,292 | 732,292 | 12,822,067 | 12,822,067 |
DeeDee DoubleEntry, Incorporated | |||
Adjusting Journal Entries | |||
For the Year Ended December31, 2017 | |||
Item | Account Title | Dr. | Cr. |
a. | Restricted Cash | 27,000 | |
Cash | 27,000 | ||
b. | Allowance for Doubtful Accounts | 67,000 | |
Bad Debt Expense | 67,000 | ||
c. | Office Supplies Expense | 2941 | |
Office Supplies | 2941 | ||
d. | Prepaid Rent | 7500 | |
Rent Expense - Storage Facility | 7500 | ||
e. | Interest Receivable | 688 | |
Interest Revenue on Note Receivable | 688 | ||
f. | Insurance Expense | 5211 | |
Prepaid Insurance | 5211 | ||
g. | Depreciation Expense - Office Building | 38750 | |
Accumulated Depreciation - Office Building | 38750 | ||
h. | Office Salaries Expense | 17000 | |
Sales Salaries Expense | 25500 | ||
Salaries Payable | 39249 | ||
Payroll Taxes Payable | 3251 | ||
i. | Prepaid Advertising | 12000 | |
Advertising Expense | 12000 | ||
j. | Unearned Rent Revenue | 25263 | |
Rent Revenue | 25263 | ||
k. | Accumulated Other Comprehensive Income | 89000 | |
Available for Sale Securities | 89000 | ||
l. | Depreciation Expense - Office Equipment | 16600 | |
Accumulated Depreciation - Office Equipment | 16600 | ||
m. | Sales | 19821 | |
Sales Tax Payable | 19821 | ||
n. | Amortization Expense | 31250 | |
Accumulated Amortization | 31250 | ||
o. | Depreciation Expense - Storage Building | 46667 | |
Accumulated Depreciation - Storage Building | 46667 | ||
p. | Leasehold Improvements | 5459 | |
Miscellaneous Selling Expense | 5459 | ||
Depreciation Expense - Leasehold Improvements | 728 | ||
Accumulated Depreciation - Leasehold Improvements | 728 | ||
q. | Interest Expense | 17500 | |
Interest Payable | 17500 | ||
Interest Expense | 110250 | ||
Interest Payable | 110250 | ||
r. | Warranty Expense | 5709 | |
Warranty Liability | 5709 | ||
s. | Merchandise Inventory | 3700 | |
Cost of Goods Sold | 3700 | ||
t. | Income Tax Expense | 245,756.00 | |
Income Tax Payable | 245,756.00 |
DeeDee does banking at three different financial institutions.The details are as DeeDee Double Entry
Bank | Account # | Balance |
Coterica | 123456 | 175,000 |
Coterica | 123457 | (10,000) |
4th BAnk | 345689 | 82,000 |
Bank Two | 397567 | (6,700) |
a. You also note the Board of Directors has restricted $27,000of cash for future expansion. This $27,000 is part of the cashbalance. The future expansion will not occur for several moreyears.
b. Based on your inquiries, you note that $67,000 of accountsreceivable had been written off during the year. The clerk haddebited bad debt expense for $67,000 and credited AccountsReceivable for $67,000. When $15,000 of accounts previously writtenoff had been collected, the accountant debited cash and creditedsales. The company uses the allowance method based on the aging ofaccounts receivable. Based on this method, DeeDee determines thatuncollectible accounts are $89,000 at the end of 2017. (Replace theX with the last digit of your student number).
c. Per a physical count of office supplies, $4,859 (enter thelast two digits of your student number) of supplies remained at theend of 2017. The balance on the worksheet in the office suppliesaccount represents last years ending balance. During the year,$28,500 of office supplies were purchased and immediatelyexpensed.
d. Because of strong demand and a need for additional inventory,DeeDee needed some temporary additional storage space so on June 1,2017 they rented a unit for an annual rate of $18,000 and they paidthe entire amount up front.
e. On November 1st, 2017, (Enter your birthday month) DeeDeeloaned a key supplier, $75,000. A promissory note was signed andissued. The agreed upon interest rate was 5.5% and the key supplierhas agreed to pay interest and $15,000 of the principle eachJanuary 1st. The note was recorded in Notes Receivableand is the only note outstanding.
f. On February 1, 2017, DeeDee renewed a 19 month insurancepolicy for $9,000. All cash was paid at the time the policy wassigned and prepaid insurance was increased. (Replace the X with thelast digit of your student number.) All other transactionsinvolving insurance were properly recorded.
g. The office building was bought in January 1, 2015 by DeeDeeand DeeDee originally planned to use the building for 40 years andestimated no salvage value. DeeDee depreciates the building on a straightline basis. Now in 2017, DeeDee estimates the total life to remain at 40 years,but believes the salvage will be $900,000. (Replace theX with the last digit of your student number.)
h. DeeDee is open seven days a week and has a daily payroll of$8500. Employees are paid every Friday, December 31 is a Wednesday.40% of the payroll is for office employees, 60% of payroll is forsales employees. The employer portion of FICA expense is 7.65% andno employee has reached the maximum. DeeDee records payroll taxexpenses in salary expense.
i. On December 1, 2017 DeeDee paid ABC Advertising $16,000 for afour month campaign of advertising services. Equal services areprovided each month. All other advertising paid forduring the year has been consumed.
j. On August 1, 2017, DeeDee rented a portion of one store toMarketing Majors Inc. The contract was for 19 (enter the last digitof your student number) months and DeeDee required all of the cashup front. The rent is being earned equally each month. This is theonly item in which rent is being earned by the company.
k. As of 12/31/2017 the Available for Sale Securities have afair value of $291,000 (enter the last digit of your student numberin place of the X). Due to the market conditions, the company doesnot plan on selling the assets in 2017, but their intent is to sellat some point in time. You can ignore the tax effect onunrealized gains and losses. (Hint: Unrealized Gains andLosses are closed to Accumulated Other Comprehensive Income at theend of the year.)
l. DeeDee uses the DDB method to depreciate office equipment. Nooffice equipment was added during 2017. It is estimated that theoffice equipment has a useful life of 10 years with a salvage valueof $2,000. Prior depreciation was correctly calculated based onperiod of time held.
m. After reviewing details of sales, you note that the salestaxes collected on the last week of Decemberâs sales were includedin sales revenue. Sales recorded the last week of December thatincluded the sales tax of 12% (enter your birthday month plus 1)amounted to $185,000.
n. On November 1, 2017 (enter your birthday month), DeeDeerecorded a patent in the amount of $250,000. The company paidoutside legal fees of $120,000 to have the patent registered. Theother $130,000 represents internal costs in developing the patent.The patent is good for 20 years, but the company estimates that thepatent will have a useful life of 8 years with no residual value.No one knows what to do with this information so no amortizationhas been recorded for 2017. Amortization is straight line and thecompany depreciates using partial years for intangible assets.
o. The storage building was self-constructed this year byDeeDee. The Company had their initial expenditure of $700,000 onJanuary 1. They paid an additional $500,000 on March 1st, $300,000 on June 1st, and then the final payment of$150,000 on August 1st. when the building was completedand occupancy occurred. Payments to contractor were properlycapitalized. The company has decided to use S/L method fordepreciation. The storage building is estimated to have a life of30 years and a savage value of $250,000. The companywill take a full year of depreciation in year of acquisition.
p. You note that Leasehold Improvements have not beendepreciated for this year. DeeDee started to lease some new retailspace in 2017 and added shelving and fixtures to this leased space.Based on your review of invoices, the previous accountantcapitalized the cost of fixtures but did not capitalize theshipping and installation costs of $5,459 ((enter the last threedigits of your student number in place of the XXX). . These costswere expensed and recorded as a miscellaneous administrativeexpense. DeeDee has decided to use double declining balance (DDB)depreciation for this item and to take a full year of depreciationin the year of acquisition. The leasehold improvements have auseful life of 15 years with a salvage value of$10,000.
q. DeeDee Double Entry has two loans outstanding as of12/31/2017. Interest is paid annually on January 1st. The facts on each loan are asfollows: Onstar Bank Loan â outstanding since January 1, 2017 with a 3.5%interest rate. This loan was taken out to finance the constructionof the Storage Building. Interest for the year and 15% of theprinciple will be paid to the bank on January 1, 2018. Except forrecording the initial cash received and loan, no additional entries have beenmade. Coldstar Bank Loan â also outstanding all of 2017 with a 4.9% interest rate (enter the last digit of your student number).Interest is due on January 1, 2018. Principle is due on January 1,2023. Since interest will not be paid to the Bank until 2018,DeeDeeâs office staff did not accrue any interest.
r. DeeDee added a one-year warranty to one of its computer gamesthis year. It is estimated that the total cost of servicing thewarranties on the 2017 sales will be $10,459 (enter the last threedigits of your student number). During 2017, $4,750 wasrefunded to customers for warranty issues on 2017 sales andrecorded as warranty expense.
s. DeeDee uses the FIFO Inventory Method in valuing inventory.The inventory balance of $187,500 was based on a physical count at12/31/2017. Based on your analysis, you have noted that $12,500 ofmarketing games that belonged to Marketing Majors Inc. was includedin the account. You also note that goods were in transit from avendor on December 31, 2017. The cost of the inventory was $16,200and the goods were shipped f.o.b. shipping point on December 29,2017.
t. DeeDee has a straight tax rate of 28%. Income tax expense isNet Income before taxes times 28%. (Hint: Prepare the IncomeStatement up to Net Income before Taxes and then record thisadjusting journal entry.
Czar was authorized to issue 3,000,000 shares of $1 par Common Stock but has only issued 520,000 shares of common stock as of 12/31/2018. No new shares were issued during 2018.
1. On the âAdjusting Journal Entriesâ worksheet, prepare in journal entry form all adjusting and correcting journal entries based on the following information. All information was provided to you as of 12/31/2018. (Round all numbers to the nearest dollar). Label journal entries a through t.
P- On 2,1, 2018, Czar rented a portion of one store to Pellston Inc. The contract was for 15 months and Czar required all of the cash up front. The rent is being earned equally each month. This is the only item in which rent is being earned by the company.
Q- Czar started to lease some new retail space in 2018 and added shelving and fixtures to this leased space. Based on your review of invoices, the previous accountant capitalized the cost of fixtures but did not capitalize the shipping and installation costs of $2,815. These costs were expensed and recorded as a miscellaneous selling expense. Czar has decided to use double declining balance (DDB) depreciation for this item and to take a full year of depreciation in the year of acquisition. The leasehold improvements have a useful life of 15 years with a salvage value of $12,000.
R- Czar uses the FIFO Inventory Method in valuing inventory. The inventory balance of $340,000 was based on a physical count at 12/31/2018. Based on your analysis, you have noted that $10,000 of marketing games that belonged to Pellston Inc. was included in the account. You also note that $5,600 of goods shipped to Czar f.o.b. destination were in transit on December 31, 2018 and included in the physical count.
Czar Incorporated | ||||||
End of Period Worksheet | ||||||
For the Year Ended December 31, 2018 | ||||||
Unadjusted | Adjusted | |||||
Account Title | Trial Balance | Adjustments | Trial Balance | |||
DR | CR | DR | CR | DR | CR | |
Cash | 264,000 | - | ||||
Accounts Receivable | 555,984 | - | ||||
Allowance for Doubtful Accounts | - | 13,600 | ||||
Interest Receivable | - | - | ||||
Merchandise Inventory | 340,000 | - | ||||
Prepaid Insurance | - | - | ||||
LIFO Reserve | - | 25,600 | ||||
Prepaid Advertising | - | - | ||||
Prepaid Rent | 13,600 | - | ||||
Office Supplies | 4,800 | - | ||||
Note Receivable | 20,000 | |||||
Available for Sale Securities | 300,000 | - | ||||
Office Building | 3,000,000 | - | ||||
Accumulated Depreciation - Office Building | - | 70,000 | ||||
Storage Building | 1,020,000 | - | ||||
Accumulated Depreciation - Storage Building | - | - | ||||
Land | 600,000 | - | ||||
Leasehold Improvements | 180,000 | - | ||||
Accumulated Depreciation - Leasehold Improvements | - | - | ||||
Office Equipment | 260,000 | - | ||||
Accumulated Depreciation - Office Equipment | - | 52,000 | ||||
Patent | 120,000 | - | ||||
Accounts Payable | - | 276,000 | ||||
Sales Tax Payable | - | - | ||||
Salaries Payable | - | 113,600 | ||||
Payroll Taxes Payable | - | 20,000 | ||||
Interest Payable | - | - | ||||
Income Tax Payable | - | - | ||||
Unearned Rent Revenue | - | - | ||||
Loan Payable - First Trust | - | 520,000 | ||||
Loan Payable - Coldwell Bank | - | 1,600,000 | ||||
Common Stock | - | 520,000 | ||||
Additional Paid in Capital | - | 1,599,000 | ||||
Retained Earnings | - | 736,000 | ||||
Accumulated Other Comprehensive Income | - | 20,000 | ||||
Dividends | 67,800 | - | ||||
Sales | - | 3,622,560 | ||||
Sales Returns and Allowances | 33,800 | - | ||||
Sales Discounts | 15,400 | - | ||||
Cost of Goods Sold | 1,583,600 | - | ||||
Sales Salaries Expense | 349,120 | - | ||||
Office Salaries Expense | 219,200 | - | ||||
Advertising Expense | 12,800 | - | ||||
Depreciation Expense - Office Building | - | |||||
Depreciation Expense - Leasehold Improvements | - | - | ||||
Depreciation Expense - Office Equipment | - | - | ||||
Leasing Expense - Stores | 105,600 | - | ||||
Miscellaneous Selling Expense | 18400 | - | ||||
Research & Development Expense | 12,000 | |||||
Rent Expense - Storage Facility | - | - | ||||
Insurance Expense | 12,000 | - | ||||
Office Supplies Expense | 28,000 | - | ||||
Miscellaneous Administrative Expense | 7,336 | - | ||||
Rent Revenue | - | 60,000 | ||||
Interest Revenue on Note Receivable | - | - | ||||
Dividend Revenue on AFS Securities | - | 20,000 | ||||
Interest Expense | - | - | ||||
Bad Debt Expense | 28,000 | - | ||||
Amortization Expense | - | - | ||||
Income Tax Expense | - | - | ||||
Payroll Taxes Expense | 96,920 | - | ||||
Rebate Expense | - | - | ||||
Unrealized holding loss | - | - | ||||
Depreciation Expense-Storage Building | - | - | ||||
Loss on Impairment | - | - | ||||
Rebate Liability | - | - | ||||
Restricted Cash for Future Expansion | - | - | ||||
9,268,360 | 9,268,360 |
Financial StatementAnalysis | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
a. Within this workbook there is a worksheet labeled "AdjustedTrial Balances". Within that worksheet you will find fullycompleted trial balances for three years. Also within this workbookyou will find worksheets for comparative income statements andcomparative balance sheets. Using the trial balances andcomparative financial statements you need to calculate a variety ofratios. You will find the required ratios in the worksheet labeled"Ratios Historical". Complete all the required ratios. You MUST useformulas and/or linking to compute your ratios. You can not simplyhard key the answers. You must reference the appropriate data fromthe trial balances and comparative financial statements.
|
AC Speed | |||||||||
Income Statement | |||||||||
12/31/15 | 12/31/14 | 12/31/13 | 12/31/12 | 5/31/15 | |||||
Sales Revenue | |||||||||
Sales | 8,850,000 | 8,874,000 | 9,051,480 | 9,141,995 | 725,000 | ||||
Less: Sales Returns & Allowances | 0 | 0 | 0 | 0 | 0 | ||||
Sales Discounts | 0 | 0 | 0 | 0 | 0 | ||||
Net Sales | 8,850,000 | 8,874,000 | 9,051,480 | 9,141,995 | 725,000 | ||||
Cost of Goods Sold | 7,656,000 | 7,661,551 | 7,625,748 | 7,852,006 | 638,000 | ||||
Gross Profit | 1,194,000 | 1,212,449 | 1,425,732 | 1,289,989 | 87,000 | ||||
Operating Expenses | |||||||||
Wage Expense (hourly workers) | 120,000 | 122,400 | 124,848 | 126,096 | 10,000 | ||||
Salaries Expense (Exempt Staff) | 360,000 | 367,200 | 374,544 | 378,289 | 30,000 | ||||
Marketing Expense | 288,000 | 293,760 | 299,635 | 302,632 | 24,000 | ||||
Travel and Entertainment Expense | 27,600 | 28,152 | 28,715 | 29,002 | 2,300 | ||||
Bad Debt Expense | 0 | 0 | 0 | 0 | 0 | ||||
Property Tax Expense | 0 | 0 | 0 | 0 | 0 | ||||
Office Maintenance & RepairExpense | 6,000 | 6,120 | 6,242 | 6,305 | 500 | ||||
Legal Expenses | 198,600 | 202,572 | 206,623 | 208,690 | 16,550 | ||||
Insurance Expense | 24,000 | 24,480 | 24,970 | 25,219 | 2,000 | ||||
Utilities Expense | 12,000 | 12,240 | 12,485 | 12,610 | 1,000 | ||||
Office Supplies Expense | 3,480 | 3,550 | 3,621 | 3,657 | 290 | ||||
Telecommunications Expense | 660 | 673 | 687 | 694 | 55 | ||||
Depreciation Expense - Equip &Furniture - Warehouse | 1,980 | 2,020 | 2,060 | 2,081 | 165 | ||||
Depreciation Expense - Equip &Furniture - Office | 1,680 | 1,714 | 1,748 | 1,765 | 140 | ||||
Total Operating Expenses | 1,044,000 | 1,064,880 | 1,086,178 | 1,097,039 | 87,000 | ||||
Operating Income | 150,000 | 147,569 | 339,554 | 192,950 | 0 | ||||
Other Revenues & Gains | |||||||||
Rent Income | 0 | 0 | 0 | 0 | #REF! | ||||
0 | 0 | 0 | 0 | #REF! | |||||
Other Expenses & Losses | |||||||||
Interest Expense | 0 | 0 | 0 | 0 | 0 | ||||
0 | 0 | 0 | 0 | 0 | |||||
Net Income | 150,000 | 147,569 | 339,554 | 192,950 | #REF! | ||||
Common Dividends | 19,200 | 16,130 | 15,000 | 1,600 | |||||
Weighted Average Common Shares | 65,000 | 65,000 | 65,000 | 62,500 | |||||
Market Price per Common Share | 35.00 | 34.00 | 31.00 | 34.00 |
AC Speed | |||||||||
Balance Sheet | |||||||||
12/31/15 | 1/0/00 | 12/31/14 | 1/0/00 | 12/31/13 | 1/0/00 | 12/31/12 | 1/0/00 | 5/31/15 | |
ASSETS | |||||||||
Current Assets | |||||||||
Cash | 294,000 | 311,640 | 342,804 | 373,656 | 75,000 | ||||
Accounts Receivable | 948,800 | 846,728 | 931,401 | 1,015,227 | 490,000 | ||||
Less: Allowance for Doubtful Accounts | 16,800 | 17,808 | 19,589 | 21,352 | 15,000 | ||||
Net Accounts Receivable | 932,000 | 828,920 | 911,812 | 993,875 | 475,000 | ||||
Merchandise Inventory | 601,856 | 637,967 | 701,764 | 764,923 | 334,000 | ||||
Office Supplies | 2,240 | 2,374 | 2,612 | 2,847 | 2,000 | ||||
Prepaid Insurance | 15,680 | 16,621 | 18,283 | 20,111 | 14,000 | ||||
Total Current Assets | 1,845,776 | 1,797,523 | 1,977,275 | 2,155,412 | 900,000 | ||||
Long-Term Assets | |||||||||
Land | 2,000,600 | 2,000,600 | 2,000,600 | 2,000,600 | 2,000,600 | ||||
Equipment & Furniture - Warehouse | 11,200 | 11,872 | 13,059 | 14,235 | 10,000 | ||||
Accumulated Depreciation - Equip &Furn. - Warehouse | 2,128 | 2,256 | 2,481 | 2,705 | 1,900 | ||||
Book Value: Equipment & Furniture -Warehouse | 9,072 | 9,616 | 10,578 | 11,530 | 8,100 | ||||
Equipment & Furniture - Office | 9,520 | 10,091 | 11,100 | 12,099 | 8,500 | ||||
Accumulated Depreciation - Equip &Furn. - Office | 1,792 | 1,900 | 2,089 | 2,278 | 1,600 | ||||
Book Value: Equipment & Furniture -Office | 7,728 | 8,192 | 9,011 | 9,822 | 6,900 | ||||
Total Long-Term Assets | 2,017,400 | 2,018,408 | 2,020,189 | 2,021,952 | 2,015,600 | ||||
TOTAL ASSETS | 3,863,176 | 3,815,931 | 3,997,464 | 4,177,364 | 2,915,600 | ||||
LIABILITIES | |||||||||
Current Liabilities | |||||||||
Accounts Payable | 812,432 | 861,178 | 947,296 | 978,338 | 948,600 | ||||
Wages Payable | 0 | 0 | 0 | 0 | 0 | ||||
Interest Payable | 0 | 0 | 0 | 0 | 0 | ||||
Dividends Payable | 0 | 0 | 0 | 0 | 0 | ||||
Unearned Rent | 0 | 0 | 0 | 0 | 0 | ||||
Total Current Liabilities | 812,432 | 861,178 | 947,296 | 978,338 | 948,600 | ||||
Long-Term Liabilities | |||||||||
Notes Payable | 0 | 0 | 0 | 0 | 0 | ||||
Bonds Payable | 0 | 0 | 0 | 0 | 0 | ||||
Mortgage (Warehouse) Payable | 124,000 | 131,440 | 144,584 | 157,597 | 200,000 | ||||
Total Long-Term Liablities | 124,000 | 131,440 | 144,584 | 157,597 | 200,000 | ||||
TOTAL LIABILITIES | 936,432 | 992,618 | 1,091,880 | 1,135,935 | 1,148,600 | ||||
STOCKHOLDER'S EQUITY | |||||||||
Paid-in Capital | |||||||||
Capital Stock | 65,000 | 65,000 | 65,000 | 65,000 | 60,000 | ||||
Additional Paid-in Capital | 1,545,000 | 1,545,000 | 1,545,000 | 1,545,000 | 1,341,000 | ||||
Retained Earnings | 1,316,744 | 1,213,313 | 1,295,584 | 1,431,429 | #REF! | ||||
Total Paid-in Capital & RetainedEarnings | 2,926,744 | 2,823,313 | 2,905,584 | 3,041,429 | #REF! | ||||
TOTAL LIABILITIES & CAPITAL | 3,863,176 | 3,815,931 | 3,997,464 | 4,177,364 | #REF! | ||||
TOTAL ASSETS | 3863176 | 3815930.56 | 3997463.616 | 4177364.17 | 2915600 | ||||
TOTAL LIAB & EQUITY | 3863176 | 3815930.92 | 3997464.092 | 4177363.81 | #REF! | ||||
VARIANCE | 0 | -0.36 | 0 | 0 | #REF! |
12/31/15 | 12/31/14 | 12/31/13 | INDUSTRY | ||||
Liquidity | |||||||
Current Ratio (One decimal place) | 2.1 | 2.1 | 2.2 | ||||
Current Assets | |||||||
Current Liabilities | |||||||
Acid Test Ratio (One decimal place) | 1.3 | 1.3 | 1.6 | ||||
Cash | |||||||
A/R (Net) | |||||||
Short Term Investments | |||||||
Current Liabilities | |||||||
Receivables Turnover (One decimalplace) | 10.2 | 9.5 | 10 | ||||
Net Credit Sales | |||||||
Beg A/R | |||||||
End A/R | |||||||
Avg. A/R | |||||||
Inventory Turnover (One decimalplace) | 11.4 | 10.4 | 9.5 | ||||
CGS | |||||||
Avg. Inventory | |||||||
Profitability | |||||||
Profit Margin (% with two decimalplaces) | 1.66% | 3.75% | 3.5% | ||||
Net Income | |||||||
Net Sales | |||||||
Asset Turnover (two decimal places) | 2.27 | 2.21 | 1.9 | ||||
Net Sales | |||||||
Beginning Assets | |||||||
Ending Assets | |||||||
Average Assets | |||||||
Return on Assets (% one decimalplace) | 3.8% | 8.3% | 10.5% | ||||
Net Income | |||||||
Avg. Assets | |||||||
Return on Common Shareholders' Equity | |||||||
(One decimal place) | 5.2% | 11.4% | 18.3% | ||||
Net Income | |||||||
Preferred Dividends | |||||||
Beginning Common Equity | |||||||
Ending Common Equity | |||||||
Avg. Common Shareholders' Equity | |||||||
Earnings per Share (EPS) (Two decimalplaces) | 2.27 | 5.33 | 3.05 | ||||
Net Income | |||||||
Preferred Dividends | |||||||
Weighted Avg. Common SharesOutstanding | |||||||
Price-Earnings (P/E ) Ratio (Two decimalplaces) | 14.98 | 5.93 | 14.8 | ||||
Market Price per Share of Stock | |||||||
Earnings per Share | |||||||
Payout Ratio (% One decimal place) | 10.9% | 4.4% | 15.0% | ||||
Cash Dividends | |||||||
Net Income | |||||||
Solvency Ratios | |||||||
Debt to Total Assets Ratio (% One decimalplace) | 26.0% | 27.3% | 42.2% | ||||
Total Debt | |||||||
Total Assets | |||||||
Dec. 31, 2010 | Dec. 31, 2009 | Dec. 31, 2008 | |||||
Common Dividends | 19,200 | 16,130 | 15,000 | ||||
Weighted Average Common Shares | 65,000 | 65,000 | 63,750 | ||||
Market Price per Share | 35 | 34 | 31 |