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 profit 440,357
Operating expenses:
Insurance expense 4,000
Utility expense 30,000
Rent expense 20,000
Compensation expense [A]
Bad debt expense [B]
Depreciation expense [C]
Maintenance expense 3,000
Warranty expense 21,000
Rental expense (lease) [D]
Pension expense [E]
Selling expense-Initial issuance cost 10,000
Total operating expenses [F]
Operating income [G]
Other income (expense):
Investment revenue 7,500
Interest revenue 9,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 profit 380,000
Operating expenses:
Insurance expense 6,000
Utility expense 30,000
Rent expense 20,000
Compensation expense 110,000
Bad debt expense 6,350
Depreciation expense 38,090
Maintenance expense 1,000
Warranty expense 25,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 bonds 357
Gain on sale of investment 4,000
Net income [I]
Basic EPS [J]
Diluted EPS [K]

Project 3.3 Balance Sheet

Illini Company, Inc.
Balance Sheet
12/31/20X1 12/31/20X2
Assets
Current Assets
Cash $1,336,056 $1,922,356
Short-term investment [A] [B]
Accounts receivable, net of allowance 34,150 67,800
Interest Receivable 9,636 6,999
Prepaid insurance 6,000 0
Inventory 310,000 50,000
Total current assets 1,733,841 2,047,155
Long-term investment [C] [D]
PPE, net 142,300 57,500
ROU assets, net 137,076 101,345
Investment in lease [E] [F]
Brand asset 0 16,000
Goodwill [G] [H]
Total assets [I] [J]
Liabilities and shareholders' equity
Current liabilities:
Wage payable [K] [L]
Unearned revenue 0 50,000
Estimated warranty liability 11,000 6,000
Accrued interest 12,704 9,445
Current portion of long-term bonds [M] [N]
Current portion of lease obligation [O] [P]
Total current liabilities 66,786 121,609
Non-current portion of long-term bonds [Q] [R]
Non-current portion of lease obligation [S] [T]
Pension liability 2,000 9,800
Total liabilities 286,437 236,341
Shareholders' equity:
Common stock [U] [V]
Additional paid-in capital - common stock 280,000 316,600
Preferred stock 100,000 100,000
Treasury stock [W] [X]
Retained earnings [Y] [Z]
Accumulated other comprehensive income [i] [ii]
Total shareholders' equity 1,919,138 2,070,652
Total liabilities and shareholders' equity $2,205,575 $2,306,992

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

Finance For Real Estate Development

Authors: Charles Long

1st Edition

0874204305, 978-0874204308

More Books

Students also viewed these Finance questions