The following is the ending balances of accounts at June 30, 2021, for Excell Company.
Account Title Debits Credits
Cash $ 93,000
Short-term investments 75,000
Accounts receivable (net) 290,000
Prepaid expenses (for the next 12 months) 42,000
Land 85,000
Buildings 330,000
Accumulated depreciation—buildings $ 165,000
Equipment 270,000
Accumulated depreciation—equipment 125,000
Accounts payable 178,000
Accrued liabilities 50,000
Notes payable 110,000
Mortgage payable 240,000
Common stock 150,000
Retained earnings 167,000
Totals $ 1,185,000 $ 1,185,000
Additional information:
The short-term investments account includes $23,000 in U.S. treasury bills purchased in May. The bills mature in July, 2021.
The accounts receivable account consists of the following:
a. Amounts owed by customers $ 232,000
b. Allowance for uncollectible accounts—trade customers (18,000 )
c. Nontrade notes receivable (due in three years) 70,000
d. Interest receivable on notes (due in four months) 6,000
Total $ 290,000
The notes payable account consists of two notes of $55,000 each. One note is due on September 30, 2021, and the other is due on November 30, 2022.
The mortgage payable is a loan payable to the bank in semiannual installments of $4,800 each plus interest. The next payment is due on October 31, 2021. Interest has been properly accrued and is included in accrued expenses.
Eight hundred thousand shares of no par common stock are authorized, of which 300,000 shares have been issued and are outstanding.
The land account includes $55,000 representing the cost of the land on which the company's office building resides. The remaining $30,000 is the cost of land that the company is holding for investment purposes.

Answer:

Total Assets $895,000

Total liabilities and stockholders'equity $895,000

Explanation:

Preparation of a classified balance sheet for the Excell Company at June 30, 2021

EXCELL COMPANY Balance Sheet At June 30, 2021

ASSETS

Current assets:

Cash and cash equivalents $116,000

($93,000+$23,000)

Short-term investments $52,000

($75,000-$23,000)

Accounts receivable, net of allowance for uncollectible accounts $214,000

($232,000-$18,000)

Interest receivable $6,000

Prepaid expenses $42,000

Total current assets $430,000

($116,000+$52,000+$214,000+$6,000+$42,000)

Investments:

Note receivable $70,000

Land held for sale $30,000

$100,000

($70,000+$30,000)

Property, plant, and equipment:

Land $55,000

Buildings $330,000

Equipment $270,000

($55,000+$330,000+$270,000)

$655,000

Less: Accumulated depreciation ($290,000)

Net property, plant, and equipment $365,000

($655,000-$290,000)

TOTAL ASSETS $895,000

($430,000+$100,000+$365,000)

LIABILITIES AND STOCKHOLDERS'S EQUITY

Current liabilities:

Accounts payable $178,000

Accrued expenses $50,000

Note payable $55,000

Current maturities of long-term debt $9,600

(4800*2)

Total current liabilities $292,600

($178,000+$50,000+$55,000+$9,600)

Long-term liabilities:

Note payable $55,000

Mortgage payable $230,400

($240,000-$9,600)

Total long-term liabilities $285,400

($55,000+$230,400)

Shareholders’ equity:

Common stock, no par value; 800,000 shares

authorized; 300,000 shares issued and outstanding $150,000

Retained earnings $167,000

Total shareholders ’equity $317,000

($150,000+$167,000)

TOTAL LIABILITIES AND STOCKHOLDERS'S EQUITY $895,000

($292,600+$285,400+$317,000)

Therefore the classified balance sheet for the Excell Company at June 30, 2021 will be :

Total Assets $895,000

Total liabilities and stockholders'equity $895,000

Answer each of the following independent questions. Required: Alex Meir recently won a lottery and has the option of receiving one of the following three prizes: (1) $88,000 cash immediately, (2) $34,000 cash immediately and a six-period annuity of $9,300 beginning one year from today, or (3) a six-period annuity of $18,400 beginning one year from today. (FV of $1, PV of $1, FVA of $1, PVA of $1, FVAD of $1 and PVAD of $1) (Use appropriate factor(s) from the tables provided.) 1.1 Assuming an interest rate of 7%, determine the PV value for the above options.
1.2 Which option should Alex choose? Option (1) Option (2) Option (3)
2. The Weimer Corporation wants to accumulate a sum of money to repay certain debts due on December 31, 2022. Weimer will make annual deposits of $175,000 into a special bank account at the end of each of 10 years beginning December 31, 2013. Assuming that the bank account pays 8% interest compounded annually, what will be the fund balance after the last payment is made on December 31, 2022?
Table of calculation function?
Payment?
N?
I?
Future value?

The cost of direct materials transferred into the Bottling Department of the Mountain Springs Water Company is $327,600. The conversion cost for the period in the Bottling Department is $528,000. The total equivalent units for direct materials and conversion are 25,200 and 8,800 liters, respectively. Determine the direct materials and conversion cost per equivalent unit. Round your answers to the nearest cent. $fill in the blank 1 per equivalent unit of materials $fill in the blank 2 per equivalent unit of conversion costs

Chen Company's Small Motor Division manufactures a number of small motors used in household and office appliances. The Household Division of Chen then assembles and packages such items as blenders and juicers. Both divisions are free to buy and sell any of their components internally or externally. The following costs relate to small motor LN233 on a per unit basis.
Fixed cost per unit $5.20
Variable cost per unit $10.81
Selling price per unit $34.55
Assuming that the Small Motor Division has excess capacity, compute the minimum acceptable price for the transfer of small motor LN233 to the Household Division. (Round answer to 2 decimal places.)
Minimum transfer price $ per unit
Assuming that the Small Motor Division does not have excess capacity, compute the minimum acceptable price for the transfer of the small motor to the Household Division. (Round answer to 2 decimal places.)

Your job pays you only once a year for all the work you did over the previous 12 months. Today, December 31, you just received your salary of $58,000 and you plan to spend all of it. However, you want to start saving for retirement beginning next year. You have decided that one year from today you will begin depositing 3 percent of your annual salary in an account that will earn 11 percent per year. Your salary will increase at 6 percent per year throughout your career.
Required: How much money will you have on the date of your retirement 40 years from today?

Which of the following statements about annuities are true? Check all that apply. An ordinary annuity of equal time earns less interest than an annuity due. Annuities are structured to provide fixed payments for a fixed period of time. When equal payments are made at the beginning of each period for a certain time period, they are treated as ordinary annuities. When equal payments are made at the beginning of each period for a certain time period, they are treated as an annuity due.

Setrakian Industries needs to raise $48.5 million to fund a new project. The company will sell bonds that have a coupon rate of 5.56 percent paid semiannually and that mature in 10 years. The bonds will be sold at an initial YTM of 6.13 percent and have a par value of $2,000. How many bonds must be sold to raise the necessary funds

Below are several names of companies and their founders. Explain whether the business creates and sells innovative products or uses innovative methods or both