Answered step by step
Verified Expert Solution
Link Copied!
Question
1 Approved Answer

There are three exercises in Project 3: Project 3.1 Balance Sheet & Income Statement Part I, Project 3.2 Balance Sheet & Income Statement Part II,

    • There are three exercises in Project 3: Project 3.1 Balance Sheet & Income Statement Part I, Project 3.2 Balance Sheet & Income Statement Part II, and Project 3.3. Balance Sheet & Income Statement Part III.
    • Please read the following instructions and review the table carefully. Then, enter answers for journal items ([A] to [K] for Project 3.1, [A] to [K] for Project 3.2 and [A] to [Z], parts [i] and [ii] for Project 3.3) in the next three items in this Lesson, called Project 3: Project 3.1 Balance Sheet & Income Statement Part I, Project 3.2 Balance Sheet & Income Statement Part II, and Project 3.3. Balance Sheet & Income Statement Part III.
    • If it's a negative number, please enter a negative number (i.e. a minus sign).
    • For specific layouts of the balance sheet and income statement, please refer to the PDF file below.

    The Balance Sheet of the Illini as of 12/31/20X0:

    Illini Company, Inc.

    Balance Sheet

    as of 12/31/20X0

    Assets

    Current Assets:

    Cash

    $1,500,000

    Accounts receivable, net

    18,000

    Inventory

    50,000

    Total current assets

    1,568,000

    Equipment

    90,000

    Goodwill

    20,000

    Total assets

    $1,678,000

    Liabilities and shareholders' equity

    Shareholders' equity:

    Common stock, 20,000 shares outstanding, $1 par

    $20,000

    Additional paid-in capital

    280,000

    Retained earnings

    1,378,000

    Total shareholders' equity

    1,678,000

    Total liabilities and shareholders' equity

    $1,678,000

    • Note that all additional paid-in capital (APIC) sub accounts (e.g., APIC-options and APIC-treasury stock), if any, are tracked in the “Additional paid-in capital” account on the Balance Sheet.

    Please refer to the instructions and the table in this question. Enter the correct numeric figures in the following Balance Sheet and Income Statement for 20X1. Note that for the purpose of preparing the Balance Sheet at the end of each year:

    • For investments, you need to classify whether they are current assets (i.e., short-term investment) or non-current assets (i.e., long-term investment);
    • For bonds, you need to determine what portion of the bonds payable is current liability and what portion is non-current liability. Current portion of the bonds payable is the principal payment portion of the cash interest payments in the next year. Non-current portion is the remaining amount of the bonds payable; and
    • For leases (as the lessee), you need to determine what portion of the lease obligation is current liability and what portion is non-current liability. Current portion of the lease obligation is the principal payment portion of the cash lease payment in the next year (i.e., the amortization amount of the lease obligation in the next year). Non-current portion is the remaining amount of the lease liability.

    Project 3.1 Balance Sheet

    Illini Company, Inc.
    Income Statement
    For the Year Ended December 31, 20X1
    Sales$1,132,357
    Cost of sales (inventory/equipment)692,000
    Gross profit440,357
    Operating expenses:
    Insurance expense4,000
    Utility expense30,000
    Rent expense20,000
    Compensation expense[A]
    Bad debt expense[B]
    Depreciation expense[C]
    Maintenance expense3,000
    Warranty expense21,000
    Rental expense (lease)[D]
    Pension expense[E]
    Selling expense-Initial issuance cost10,000
    Total operating expenses[F]
    Operating income[G]
    Other income (expense):
    Investment revenue7,500
    Interest revenue9,636
    Unrealized holding losses - NI[H]
    Interest expense(22,142)
    Net income[I]
    Basic EPS[J]
    Diluted EPS[K]

    Project 3.2 Balance Sheet

    Illini Company, Inc.
    Income Statement
    For the Year Ended December 31, 20X2
    Sales$1,200,000
    Cost of sales (inventory/equipment)820,000
    Gross profit380,000
    Operating expenses:
    Insurance expense6,000
    Utility expense30,000
    Rent expense20,000
    Compensation expense110,000
    Bad debt expense6,350
    Depreciation expense38,090
    Maintenance expense1,000
    Warranty expense25,000
    Rental expense (lease)[A]
    Pension expense[B]
    Impairment of goodwill[C]
    Total operating expenses[D]
    (Loss) on sale of PPE[E]
    Operating income[F]
    Other income (expense):
    Interest revenue[G]
    Interest expense[H]
    Gain on early extinguishment of bonds357
    Gain on sale of investment4,000
    Net income[I]
    Basic EPS[J]
    Diluted EPS[K]

    Project 3.3 Balance Sheet

    Illini Company, Inc.
    Balance Sheet
    12/31/20X112/31/20X2
    Assets
    Current Assets
    Cash$1,336,056$1,922,356
    Short-term investment[A][B]
    Accounts receivable, net of allowance34,15067,800
    Interest Receivable9,6366,999
    Prepaid insurance6,0000
    Inventory310,00050,000
    Total current assets1,733,8412,047,155
    Long-term investment[C][D]
    PPE, net142,30057,500
    ROU assets, net137,076101,345
    Investment in lease[E][F]
    Brand asset016,000
    Goodwill[G][H]
    Total assets[I][J]
    Liabilities and shareholders' equity
    Current liabilities:
    Wage payable[K][L]
    Unearned revenue050,000
    Estimated warranty liability11,0006,000
    Accrued interest12,7049,445
    Current portion of long-term bonds[M][N]
    Current portion of lease obligation[O][P]
    Total current liabilities66,786121,609
    Non-current portion of long-term bonds[Q][R]
    Non-current portion of lease obligation[S][T]
    Pension liability2,0009,800
    Total liabilities286,437236,341
    Shareholders' equity:
    Common stock[U][V]
    Additional paid-in capital - common stock280,000316,600
    Preferred stock100,000100,000
    Treasury stock[W][X]
    Retained earnings[Y][Z]
    Accumulated other comprehensive income[i][ii]
    Total shareholders' equity1,919,1382,070,652
    Total liabilities and shareholders' equity$2,205,575$2,306,992

Step by Step Solution

3.36 Rating (159 Votes )

There are 3 Steps involved in it

Step: 1

To address all parts of Project 3 in a comprehensive manner each part requires specific calculations for the balance sheet income statement and journal entries across three different years and scenari... 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_2

Step: 3

blur-text-image_3

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

Molecular Cell Biology

Authors: Harvey Lodish, Arnold Berk, Chris A. Kaiser, Monty Krieger, Anthony Bretscher, Hidde Ploegh, Angelika Amon, Matthew P. Scott

7th edition

1464183393, 1464183392, 978-1429234139

More Books

Students also viewed these Accounting questions

Question

Please read the following 2 articles:...

Answered: 1 week ago

Question

How might the quote apply to this lesson?

Answered: 1 week ago