Question

In: Accounting

PLEASE SHOW WORK :D Medina Corporation keeps its book on a cash basis. At the end...

PLEASE SHOW WORK :D

Medina Corporation keeps its book on a cash basis. At the end of the year, the company’s accountant obtains the necessary information to prepare accrual basis financial statements to give to its shareholders.

The following cash flows occurred during the year ended December 31, 2020:

Cash receipts:

From customers $450,000

Interest on note 3,000

Issue of common stock 50,000

Total cash receipts $503,000

Cash disbursements:

Purchase of merchandise $220,000

Annual insurance payment 9,000

Payment of salaries 200,000

Dividends paid to shareholders 6,000

Annual rent payment 12,000

Total cash disbursements $447,000

Selected balance sheet information: LOOK AT THE DATES!!!!

12/31/19 12/31/20

Cash $25,000 $101,000

Accounts receivable 42,000 70,000

Inventory 60,000 82,000

Prepaid insurance 2,000 ?

Prepaid rent 7,000 ?

Interest receivable 1,500 ?

Note receivable 50,000 50,000

Equipment 150,000 150,000

Accumulated depreciation–equipment (40,000) (55,000)

Accounts payable (for merchandise) 50,000 62,000

Salaries payable 20,000 28,000

Common stock 200,000 250,000

Additional information:

  1. On June 30, 2019, Medina lent a customer $50,000. Interest at 6% is payable annually on each June 30. Principal is due in 2025.

  2. The annual insurance payment is made in advance on March 31.

  3. Annual rent on the company’s facilities is paid in advance on September 30.

1a. Prepare an accrual basis income statement for 2020 (ignore income taxes).

1b. Determine the following balance sheet amounts on December 31, 2020:

  1. Interest receivable

  2. Prepaid insurance

  3. Prepaid rent

Solutions

Expert Solution

Answer (1a) : Accural basis income statement:

Notes: Necessary Calculations:

1. Credit Sales = Ending balance of accounts receivablele - Begnning balance of accounts receivables

= $70,000 - $42,000

= $28,000

2. Increase in accounts payable = Ending balance of accounts payable - Begnning balance of accounts payable

= $62,000 - $ 50,000

= $12,000

3. Cost of Goods Sold = Begnning balance of inventory + Purchases - Ending balance of Inventory +  Increase in accounts payable

= $60,000 + $220,000 - $82,000 + $12,000

= $210,000

4. Insurance expense = Annual insurance payment  * Time Period

= $9,000 * 9/12

= $6,750.

5. Rent expense = Annual rent payment * Time Period

= $12,000 * 3/12

= $3,000

6. Salaries and wages expense = Cash payment of salaries + Ending salaries payable - Begnning salaries payable

= $200,000 + $28,000 - $20,000

= $208,000

7. Interest income = Principal amount * Rate of interest * Time period

= $50,000 * 6% * 6/12

= $1,500

Answer (1b) : Determination of balance sheet items at December31, 2020.

1. Interest receviable = Principal amount * Rate of interest * Time period

= $50,000 * 6% * 6/12

= $1,500

2. Prepaid Insurance = Annual insurance payment - Insurance expense for the year

= $9,000 - $6,750

= $2,250

3. Prepaid Rent = Annual rent payment - Rent expense for the year

= 12,000 - $3,000

= $9,000


Related Solutions

Handout 5 Mega keeps its accounting records on a cash basis during the year. At year...
Handout 5 Mega keeps its accounting records on a cash basis during the year. At year end, it converts its books to the accrual basis for preparing its financial statements. At the end of 2016, Mega reported the following post-closing trial balance after converting it to the accrual basis. [Hint: These will also be the beginning balances for 2017.] December 31, 2016 (accrual) Debit $ 2,700 4,200 2,100 5,600 12,000 $ 4,800 6,100 500 2,000 7,000 6,200 Credit Cash Accounts...
PLEASE SHOW WORK ( NO EXCEL) A. Project L costs $75,000, its expected cash inflows are...
PLEASE SHOW WORK ( NO EXCEL) A. Project L costs $75,000, its expected cash inflows are $15,000 per year for 12 years, and its WACC is 12%. What is the project's NPV? Do not round intermediate calculations. Round your answer to the nearest cent. B. Project L costs $61,049.98, its expected cash inflows are $13,000 per year for 9 years, and its WACC is 9%. What is the project's IRR? Round your answer to two decimal places. C. Project L...
please show work, thank you! Online Corp. decided to invest its excess cash in debt and...
please show work, thank you! Online Corp. decided to invest its excess cash in debt and equity securities. The following securities were purchased on January 2, 2017: Bonds issued by the Jata Corp. The bonds have a face value of $100,000, a 10 year life, and a stated interest rate of 5%. Interest is paid annually on December 31st. The bonds were purchased at $108,111 to yield 4% and Online classifies the debt investment as Available for Sale. 8,000 shares...
please show work, thank you! Online Corp. decided to invest its excess cash in debt and...
please show work, thank you! Online Corp. decided to invest its excess cash in debt and equity securities. The following securities were purchased on January 2, 2017: Bonds issued by the Jata Corp. The bonds have a face value of $100,000, a 10 year life, and a stated interest rate of 5%. Interest is paid annually on December 31st. The bonds were purchased at $108,111 to yield 4% and Online classifies the debt investment as Available for Sale. 8,000 shares...
please show work, thank you! Online Corp. decided to invest its excess cash in debt and...
please show work, thank you! Online Corp. decided to invest its excess cash in debt and equity securities. The following securities were purchased on January 2, 2017: Bonds issued by the Jata Corp. The bonds have a face value of $100,000, a 10 year life, and a stated interest rate of 5%. Interest is paid annually on December 31st. The bonds were purchased at $108,111 to yield 4% and Online classifies the debt investment as Available for Sale. 8,000 shares...
please show work, thank you! Online Corp. decided to invest its excess cash in debt and...
please show work, thank you! Online Corp. decided to invest its excess cash in debt and equity securities. The following securities were purchased on January 2, 2017: Bonds issued by the Jata Corp. The bonds have a face value of $100,000, a 10 year life, and a stated interest rate of 5%. Interest is paid annually on December 31st. The bonds were purchased at $108,111 to yield 4% and Online classifies the debt investment as Available for Sale. 8,000 shares...
PLEASE SHOW ALL YOUR WORK! Dillard Company starts the year with $10,000 in its cash account,...
PLEASE SHOW ALL YOUR WORK! Dillard Company starts the year with $10,000 in its cash account, $10,000 in its equipment account, $2,000 in accumulated depreciation and $18,000 in its retained earnings account. During the year Dillard sells the equipment for $8,570. After the sale of equipment is recorded, the retained earnings account will have a balance of $________. 18000-1430 (which was from 10000 of equip minus 8570)-2000 is 14570 = wrong ======================================= Uber Inc purchased a car for $43,100. The...
PLEASE SHOW YOUR WORK WITH FORMULAS. 1.At the end of the year 2017 the assets of...
PLEASE SHOW YOUR WORK WITH FORMULAS. 1.At the end of the year 2017 the assets of the company X were 400 mill EUR and equity was 300 mill EUR. At the end of the year 2018 assets in the same company   were 500 mill EUR and equity was 400 mill. The net profit in 2018 was 100 mill EUR. a)Calculate ROA and ROE for the year 2018. b)What was indebtedness in the years 2017 and 2018? c)What is the change...
Please show your work - the answer is d) but I'm not sure why. Thank you!...
Please show your work - the answer is d) but I'm not sure why. Thank you! The time it takes to complete a Sta220 term test is normally distributed with a mean of 100 minutes with standard deviation of 14 minutes. How much time should be allowed if we wish to ensure that at least 9 out of 10 students (on average) can complete it? (round to the nearest minute) A) 115 B) 116 C) 117 D) 118 E) 119
By how much did the firm’s net income exceed its free cash flow? Please show work...
By how much did the firm’s net income exceed its free cash flow? Please show work step by step if you hand write if you calculate using excel please reveal formulas so I can learn the necessary step when using excel. Target recently reported $9,250 of sales $5,750 of oprating costs other than depreciation and $700 of depreciation. zero $0.00 amoritization $3,200 of outstanding bonds that carry a 5% interest rate federal-plus-state income tax rate was 35% In order to...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT