OpenSeas, Inc. is evaluating the purchase of a new cruise ship. The ship would cost

$ 496$496

​million, but would operate for

2020

years. OpenSeas expects annual cash flows from operating the ship to be

$ 68.6$68.6

million​ (at the end of each​ year) and its cost of capital is 11.7 %11.7%

a. Prepare an NPV profile of the purchase using discount rates of

2.0 %2.0%​,

11.5 %11.5%

and

17.0 %17.0%.

b. Identify the IRR ​(to the nearest​ 1%) on a graph.

c. Is the purchase attractive based on these​ estimates?

d. How far off could​ OpenSeas? cost of capital be​ (to the nearest​ 1%) before your purchase decision would​ change?

Note​:

Subtract the discount rate from the actual IRR. Use Excel to compute the actual IRR.

You set up your own business in merchandising sector in Scranton, PA - opening a luxury watch shop on 1/1/2020.

The following is related information about the business:

-   Specific sub-sector: Merchandising sector.

-   Location: Scranton, PA

-   Business model: merchandiser - buying and selling luxury watches.

-   Investment by owner: $1,000,000

- You hired a shop manager. In order to handle different aspects of business, you had one employee responsible for the purchasing, receiving, and storing of watches purchased. A second employee is responsible for the maintenance of account receivable records and collection from customers. A third employee has responsibility for personal records, timekeeping, preparation of payrolls, and distribution of payroll checks. As a part of his job, the shop manager would do some internal control functions. In addition, you hired one security officer, and 4 full-time sales assistants.

Requirements:

1. You are given the following economic events of the business in 2020

1/1/2020: Opened the business, invested $1,000,000 cash in the business.

1/1/2020: bought a building for the business purpose for $100,000 cash. The building has a useful economic life of 10 years.

1/1/2020: purchased 100 luxury watches for $200,000 with $100,000 cash payment, the remaining amount payable on 2/1/2021. (each watch costs $2,000)

3/1/2020: purchased 50 luxury watches for $250,000 with cash. Each watch costs $5,000.

4/1/2020: purchased 40 luxury watches for $240,000 with cash. Each costs $6,000.

6/1/2020: Sold 130 watched for $1,300,000. Of which $300,000 cash was received at the time of sale. The remaining amount to be received on 5/2/2021.

7/1/2020: paid $1,200 in advance for 12 months’ property insurance (7/1/20 to 7/1/21).

8/1/2020: borrowed $500,000 from a local Chase bank. Interest rate is 12%/year. Interest is paid every 6 months- the first payment date is 2/1/2021. Principal would be paid on 8/1/2021.

9/1/2020: to expand business, you rent a showroom in the next building. Paid $24,000 cash in advance for 12 month’s rent.

12/31/2020: Paid 2020 utilities expense, advertising expense, and miscellaneous expense for $5000, $15,000, and $4,000, respectively.

Salary is paid on the last day of each month. Each month’s salary expense is $20,000.

Notes:

• On 12/31/2020: Physical inventory showed that there were 60 luxury watches on hand at the end of the period. The company used periodic inventory system, and used FIFO costing method.
• Your business used straight-line depreciation method for all fixed assets.
• Ignore tax.

Requirement: Prepare an excel file that includes

Prepare Statement of retained earnings for year ended 12/31/2020

You set up your own business in merchandising sector in Scranton, PA - opening a luxury watch shop on 1/1/2020.

The following is related information about the business:

-   Specific sub-sector: Merchandising sector.

-   Location: Scranton, PA

-   Business model: merchandiser - buying and selling luxury watches.

-   Investment by owner: $1,000,000

- You hired a shop manager. In order to handle different aspects of business, you had one employee responsible for the purchasing, receiving, and storing of watches purchased. A second employee is responsible for the maintenance of account receivable records and collection from customers. A third employee has responsibility for personal records, timekeeping, preparation of payrolls, and distribution of payroll checks. As a part of his job, the shop manager would do some internal control functions. In addition, you hired one security officer, and 4 full-time sales assistants.

Requirements:

1. You are given the following economic events of the business in 2020

1/1/2020: Opened the business, invested $1,000,000 cash in the business.

1/1/2020: bought a building for the business purpose for $100,000 cash. The building has a useful economic life of 10 years.

1/1/2020: purchased 100 luxury watches for $200,000 with $100,000 cash payment, the remaining amount payable on 2/1/2021. (each watch costs $2,000)

3/1/2020: purchased 50 luxury watches for $250,000 with cash. Each watch costs $5,000.

4/1/2020: purchased 40 luxury watches for $240,000 with cash. Each costs $6,000.

6/1/2020: Sold 130 watched for $1,300,000. Of which $300,000 cash was received at the time of sale. The remaining amount to be received on 5/2/2021.

7/1/2020: paid $1,200 in advance for 12 months’ property insurance (7/1/20 to 7/1/21).

8/1/2020: borrowed $500,000 from a local Chase bank. Interest rate is 12%/year. Interest is paid every 6 months- the first payment date is 2/1/2021. Principal would be paid on 8/1/2021.

9/1/2020: to expand business, you rent a showroom in the next building. Paid $24,000 cash in advance for 12 month’s rent.

12/31/2020: Paid 2020 utilities expense, advertising expense, and miscellaneous expense for $5000, $15,000, and $4,000, respectively.

Salary is paid on the last day of each month. Each month’s salary expense is $20,000.

Notes:

• On 12/31/2020: Physical inventory showed that there were 60 luxury watches on hand at the end of the period. The company used periodic inventory system, and used FIFO costing method.
• Your business used straight-line depreciation method for all fixed assets.
• Ignore tax.

Requirement: Prepare an excel file that includes

Prepare a balance sheet as of 12/31/2020

Sandhill Growth Company is testing a number of new agricultural seeds that it has recently harvested. To stimulate interest, it has decided to grant five of its largest customers the unconditional right to return these products if not fully satisfied. The right of return extends for four months. Sandhill Growth sells these seeds on account for $1,950,000 (cost $600,000) on April 2, 2020. Customers are required to pay the full amount due by June 15, 2020. The company follows IFRS.

Prepare the journal entry for Sandhill Growth at April 2, 2020, assuming Sandhill Growth estimates returns of 20% based on prior experience. (Credit account titles are automatically indented when the amount is entered. Do not indent manually. If no entry is required, select "No Entry" for the account titles and enter 0 for the amounts.)

eTextbook and Media

List of Accounts

Assume that one customer returns the seeds on July 1, 2020. Prepare the journal entry to record this transaction, assuming this customer purchased $130,000 of seeds from Sandhill Growth. (Credit account titles are automatically indented when the amount is entered. Do not indent manually. If no entry is required, select "No Entry" for the account titles and enter 0 for the amounts.)

eTextbook and Media

List of Accounts

Prepare the journal entry for Sandhill Growth at April 2, 2020, assuming Sandhill Growth estimates returns of 20% based on prior experience. Sandhill follows ASPE. (Credit account titles are automatically indented when the amount is entered. Do not indent manually. If no entry is required, select "No Entry" for the account titles and enter 0 for the amounts.)

eTextbook and Media

List of Accounts

Assume that one customer returns the seeds on July 1, 2020.

Prepare the journal entry to record this transaction, assuming this customer purchased $130,000 of seeds from Sandhill Growth. Sandhill follows ASPE. (Credit account titles are automatically indented when the amount is entered. Do not indent manually. If no entry is required, select "No Entry" for the account titles and enter 0 for the amounts. Round answers to 0 decimal places, e.g. 5,275.)

Marmidan Mold Shop Inc. designs and builds molds for the automotive and aircraft industries. The account balances in the company’s general ledger on January 1, 2020 (first day of the new annual fiscal year) were as follows (all account balances are in their normal position):

Cash                                                                    $     3,700

Accounts receivable                                                   5,900

Supplies inventory                                                    29,300

Land                                                                        168,500  

Buildings                                                                 116,500

Accumulated depreciation, buildings                       37,500   

Equipment                                                                 58,500

Accumulated depreciation, equipment                     18,000

Accounts payable                                                      25,200

Income tax payable                                                   16,600

Interest payable                                                           4,200

Wages payable (due in 2020)                                    15,700                                         

9% Notes payable ($10,000 due June 30, 2021,

     balance due June 30, 2022)                                  61,500

Common shares                                                       151,500

Retained earnings, Dec. 31, 2019                              52,200        

Transactions during 2020:

1.The company provided sales services to customers, on credit, for $ 210,300. In addition, the company produced cash sales to customers of $ 62,300.

2.Accounts receivable from customers of $ 15,600 remains to be collected at December 31, 2020.

3.Inventory of $ 62,900 was purchased on credit and debited to the supplies inventory account.

4.Minor parts were purchased with cash for $ 7,400 and debited to the supplies inventory account.

5.Wages payable at the beginning of 2020 were paid early in 2020. In addition, wages were earned by employees and paid during 2020 in the amount of $ 112,000.

6.Income tax payable at the beginning of 2020 was paid early in 2020.

7.Payments of $ 73,000 were made to creditors for supplies previously purchased on credit.

8.One year’s interest at 9% was paid on the notes payable at July 1, 2020.

9. During 2020, Don Tallint, the principal shareholder, purchased a new car for his wife

    Debbie. The new car cost $ 45,000 and was paid for with cash from personal sources.

10.Property taxes were paid on the land and buildings in the amount of $ 17,000 with cash.

11.Dividends were declared and paid in cash in the amount of $ 7,200.

The information available for year-end adjusting entries:

12.•Supplies inventory was counted on December 31, 2020, and it was determined the supplies inventory still on hand at yearend was $ 31,900.

13. •Annual depreciation on the buildings is $ 6,000.

14•Annual deprecation on the equipment is $ 5,500

15•Additional wages of $4,000 were earned but are unpaid and unrecorded at December 31, 2020.

16•Interest for six months at 9% per year on the notes payable is unpaid and unrecorded at December 31, 2020.

17•Income taxes of $ 16,500 were unpaid and unrecorded at December 31, 2020.

Q:Prepare any necessary adjusting journal entries for items 11 to 17 above and record the adjusting journal entries in the T accounts while adding any new T accounts that you need as you complete this task.

Marmidan Mold Shop Inc. designs and builds molds for the automotive and aircraft industries. The account balances in the company’s general ledger on January 1, 2020 (first day of the new annual fiscal year) were as follows (all account balances are in their normal position):

Cash                                                                    $     3,700

Accounts receivable                                                   5,900

Supplies inventory                                                    29,300

Land                                                                        168,500  

Buildings                                                                 116,500

Accumulated depreciation, buildings                       37,500   

Equipment                                                                 58,500

Accumulated depreciation, equipment                     18,000

Accounts payable                                                      25,200

Income tax payable                                                   16,600

Interest payable                                                           4,200

Wages payable (due in 2020)                                    15,700                                         

9% Notes payable ($10,000 due June 30, 2021,

     balance due June 30, 2022)                                  61,500

Common shares                                                       151,500

Retained earnings, Dec. 31, 2019                              52,200         

Transactions during 2020:

1.The company provided sales services to customers, on credit, for $ 210,300. In addition, the company produced cash sales to customers of $ 62,300.

2.Accounts receivable from customers of $ 15,600 remains to be collected at December 31, 2020.

3.Inventory of $ 62,900 was purchased on credit and debited to the supplies inventory account.

4.Minor parts were purchased with cash for $ 7,400 and debited to the supplies inventory account.

5.Wages payable at the beginning of 2020 were paid early in 2020. In addition, wages were earned by employees and paid during 2020 in the amount of $ 112,000.

6.Income tax payable at the beginning of 2020 was paid early in 2020.

7.Payments of $ 73,000 were made to creditors for supplies previously purchased on credit.

8.One year’s interest at 9% was paid on the notes payable at July 1, 2020.

9. During 2020, Don Tallint, the principal shareholder, purchased a new car for his wife

    Debbie. The new car cost $ 45,000 and was paid for with cash from personal sources.

10.Property taxes were paid on the land and buildings in the amount of $ 17,000 with cash.

11.Dividends were declared and paid in caah in the amount of $ 7,200.

Information available for year end adjusting entries:

12.•Supplies inventory was counted on December 31, 2020 and it was determined the supplies inventory still on hand at yearend was $ 31,900.

13. •Annual depreciation on the buildings is $ 6,000.

14•Annual deprecation on the equipment is $ 5,500

15•Additional wages of $4,000 were earned but are unpaid and unrecorded at December 31, 2020.

16•Interest for six months at 9% per year on the notes payable is unpaid and unrecorded at December 31, 2020.

17•Income taxes of $ 16,500 were unpaid and unrecorded at December 31, 2020.

Required:

Prepare any necessary adjusting journal entries for items 11 to 17 above and record the adjusting journal entries in the T accounts while adding any new T accounts that you need as you complete this task.( Record your journal entries on the electronic worksheet )

Estimating and Recording Bad Debt Estimates and Write-offs; Reporting of Accounts Receivable

At December 31, 2020, its annual year-end, the accounts of Sun Systems Inc. show the following.

1. Sales revenue for 2020, $468,000, of which one-sixth was on account.
2. Allowance for doubtful accounts, balance December 31, 2019, $2,340 credit.
3. Accounts receivable, balance December 31, 2020 (prior to any write-offs of uncollectible accounts during 2020), $46,930.
4. Uncollectible accounts to be written off, December 31, 2020, $2,730.
5. Aging schedule at December 31, 2020, showing the following breakdown of total accounts receivable, excluding amounts to be written off.

Required

a. Prepare the 2020 entry to write off the uncollectible accounts.

b. Prepare the 2020 adjusting entry to record bad debt expense for each of the following separate assumptions concerning expected bad debt loss rates. Note: Treat each of the following scenarios separately, they are independent of one another.

1. Bad debt expense is based on credit sales, 1.5%. (Hint: See p. 8-19: Alternative to Estimating Net Realizable Value)

2. The Allowance for Doubtful accounts is based on total receivables at year-end, 2.5%.

3. The Allowance for Doubtful accounts is based on aging schedule: not past due, 0.5%; past due 1–60 days, 1%; and past due over 60 days, 8%.

4. Bad debt expense is based on direct write-off method (assume entry in part a has not been recorded).

c. Prepare the 2020 balance sheet disclosure relating to accounts receivable for each assumption 1 through 4 of part b.

a.

b. Note: Treat each scenario separately, they are independent of one another.

1.

2.

3.

4.

c.  

Note: Do not use negative signs with your answers.

. Prepare the necessary journal entry on September 30, 2020 to account for:

CAD$3,045 on hand from tips up to March 31, 2020, its pre-COVID operations when the exchange rate was CAD$1 = $2.01 XCD. On September 30, 2020, the exchange rate was CAD$1 = $1.95 XCD

Ink Spill, a printing company, provides printing services to its customers. Customers normally pay for printing services in advance. In October 2020, Ink Spill received $20,000 from customers for services to be provided in November 2020. A senior accountant at Ink Spill wants to record the full amount as a liability in the company’s Balance Sheet at the end of October 2020.

Required:

Should the $20,000 be recorded as a liability in the company’s Balance Sheet at the end of October 2020? Explain, using the definition and recognition criteria of a liability in your explanation.