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.

Answers

Answer 1

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


Related Questions

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.)

Answers

Answer:

See below

Explanation:

1. If the small motor division has excess capacity,

Minimum transfer price = Variable cost + Opportunity cost

Variable cost per unit = $10.81

Add:

Opportunity cost per unit = $0.00 (Because the company has sufficient excess capacity)

Minimum transfer price = $10.81

2. If the small motor division has excess capacity,

Minimum transfer price = Variable cost + Opportunity cost

Variable cost per unit = $10.81

Add:

Opportunity cost per unit = $23.74 (As the company has no excess capacity, contribution lost is the opportunity cost)

Minimum transfer price = $34.55

N.B

Contribution lost = Selling price per unit - Variable cost per unit

= $34,55 - $10.8 = $23.74

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?

Answers

Answer:

The amount you will have on the date of your retirement 40 years from today is $1,904,087.20.

Explanation:

This can be determined using the formula for calculating the future value of growing annuity as follows:

FV = M * (((1 + r)^n - (1 + g)^n) / (r - g)) ...................................... (1)

Where

FV = Future value or the amount on the date of retirement = ?

M = First annual deposit = Annual salary * Deposit percentage = $58,000 * 3% = $1,740

r = annual interest rate = 11%, or 0.11

g = salary growth rate = 6%, or 0.06

n = number of years = 40 years

Substituting all the values into equation (1), we have:

FV = $1,740 * (((1 + 0.11)^40 - (1 + 0.06)^40) / (0.11 - 0.06))

FV = $1,740 * 1,094.30298736951

FV = $1,904,087.20

Therefore, the amount you will have on the date of your retirement 40 years from today is $1,904,087.20.

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?

Answers

Answer:

option 1

$4,056,237.49

Explanation:

To determine the better option, we have to determine the present value of options 2 and 3

Present value is the sum of discounted cash flows

Present value can be calculated using a financial calculator

option 2

Cash flow in year 0 = $34,000

Cash flow in year 1  to 6 =  $9,300  

I = 7 %

PV =  78,328.82

Option 2

Cash flow in year 1  to 6 =  $$18,400

I = 7 %

PV = 87704.33

To find the NPV using a financial calculator:

1. Input the cash flow values by pressing the CF button. After inputting the value, press enter and the arrow facing a downward direction.

2. after inputting all the cash flows, press the NPV button, input the value for I, press enter and the arrow facing a downward direction.  

3. Press compute  

It is the first option that has the highest value

The formula for calculating future value = A / annuity factor

Annuity factor = {[(1+r) n] - 1} / r

P = Present value  

R = interest rate  

N = number of years  

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

Answers

Answer:

my Answer is a products is notikdd

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

Answers

Answer:

25,317 unit

Explanation:

Current price of bond = PV(Rate, Nper, Pmt, Fv)

Current price of bond = PV(6.13%/2, 10*2 ,5.56%/2*2000, 2000)

Current price of bond = $1,915.71

Number of bonds to issue = $48,500,000 / $1,915.71

Number of bonds to issue = 25316.98430

Number of bonds to issue = 25,317 unit

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

Answers

Answer:

$13 per Equivalent Unit of Materials,

$60 per Equivalent Unit of Conversion Costs

Explanation:

Calculation to Determine the direct materials and conversion cost per equivalent unit

Direct materials equivalent units=($327,600/25,200 liters )

Direct materials equivalent units=$13

Conversion Costs equivalent units

=($528,000/8,800 liters)

Conversion Costs equivalent units= $60

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.

Answers

Answer:

The true statements are:

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 an annuity due.

Explanation:

Annuities provide fixed payments for a lifetime or a specified period of time.  With equal payments at the beginning of each period for a fixed period of time, the annuity is regarded as an annuity due.  But with equal payments at the end of the period, it is an ordinary annuity.  A common example of annuity due is payment for Rent at the beginning of the month or year.  If the Rent is paid at the end of the month or year, it is an ordinary annuity.

Other Questions
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 probability distribution for arandom variable x is given in the table.-10-505101520Probability.20.15.05.1.25.1.15Find the probability that x = -10 Which expressions are equivalent to 5x-15? Select three options.5(X+15)5(x-3)4x+3y-15-3y+X-7y-6x-8y + x0-20-3x+5+ 8x Please Help!!!!! Ill give thanks and rate best! This is a similar triangle please find the missing length. (?) 8. Is this number correctly written in scientific notation? 6.875 x 10 yes O no Why is it important for scientists to be able to remove DNA from cells? Please help!!!!!!!!!!!!!!!!!!!!!! See the lseek_example.c file. Modify the lseek_example.c, such that it reads from an input file (named "start.txt") and will print to an output file (named "end.txt") every (1+3*i)th character, starting from the 1st character in the input file. In other words, it will print the 1st character, then skip 2 characters and print the 4th one, then skip 2 characters and print the 7th one, and so on.For instance, for input file:ABCDEFGHIJKLMIt will output:ADGJMIseek_example.c file contant:// C program to read nth byte of a file and// copy it to another file using lseek#include #include #include #include void func(char arr[], int n){// Open the file for READ only.int f_read = open("start.txt", O_RDONLY);// Open the file for WRITE and READ only.int f_write = open("end.txt", O_WRONLY);int count = 0;while (read(f_read, arr, 1)){// to write the 1st byte of the input file in// the output fileif (count < n){// SEEK_CUR specifies that// the offset provided is relative to the// current file positionlseek (f_read, n, SEEK_CUR);write (f_write, arr, 1);count = n;}// After the nth byte (now taking the alternate// nth byte)else{count = (2*n);lseek(f_read, count, SEEK_CUR);write(f_write, arr, 1);}}close(f_write);close(f_read);}// Driver codeint main(){char arr[100];int n;n = 5;// Calling for the functionfunc(arr, n);return 0;} What are new stars that are found in the spiral arms and formed from recycled dead star material known as?population II starsred dwarf starspopulation I starsbrown dwarf stars What are the sins committed by Don Pedro and Don Diego against Don Juan? What is culture?Athe system of government in a countryBa way of life shared by a group of peopleConly the religion of a specific communityDonly the art and music a group produces 9. A convex lens of focal length 8 cm forms a real image of the same size as thobject. What will the distance between the object and its image be:1) 32cm2) 8cm3)16cm4)24cm Please i need help please Round 7.54 please I need help Use the following balanced reaction to solve 1-3:P4 (s) + 6H2 (g) 4PH3 (g) How many grams of phosphorus trihydride will be formed by reacting 60 L of Hydrogen gas with an excess of P4? 7. Kelly has not used the most appropriate word in sentence 17. Which word bestreplaces changes ?variesshiftsocontrols0decreasesCLEAR ALL HELP! 20 points PLEASE Redaccin sobre quin soy Determine the value of x in each figure.HELPPPPP PLEASEEEEE