Question

PLEASE POST EXCEL SPREADSHEET Record the following transactions in the financial statements effects template below. Company...

PLEASE POST EXCEL SPREADSHEET

  1. Record the following transactions in the financial statements effects template below.
  1. Company receives $6,000 from the sale of gift certificates.
  2. Customers used $5,700 gift certificates. The cost of the inventory sold is $3,900.
  3. The balance of the gift certificates expire unused.

Balance Sheet

Income Statement

Transaction

Cash Asset

+

Noncash Assets

=

Liabil-

ities

+

Contrib. Capital

+

Earned

Capital

Rev-enues

Expen-ses

=

Net

Income

a)

=

=

b)

=

=

c)

=

=

Homework Answers

Answer #1
Balance Sheet Income Statement
Transactions Cash + Non Cash Assets = Liabilities+ Contributed Earned Revenues- Expenses= Net Income
Capital + Capital
a. 6000 6000
b. -3900 -5700 1800 5700 3900 1800
c. -300 300 300 0 300
Nnote:
Unearned revenue is recognized for $ 6000 in a. transaction.
Revenue recognized for gift redeemed $ 5700 and cost of goods sold recorded as expenses $3900 and reduce the inventory balance $ 3900. Net income of $ 1800 (5700-3900) will increase the equity.
Expired certificate will be considered as revenue for the period.
Know the answer?
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Not the answer you're looking for?
Ask your own homework help question
Similar Questions
Analyzing Transactions Using the Financial Statement Effects Template Hanlon Advertising Company began the current month with...
Analyzing Transactions Using the Financial Statement Effects Template Hanlon Advertising Company began the current month with the following balance sheet. Cash $ 80,000 Liabilities $ 70,000 Noncash assets 135,000 Contributed capital 110,000 Earned capital 35,000 Total assets $215,000 Total liabilities and equity $215,000 Following are summary transactions that occurred during the current month. The company purchased supplies for $5,000 cash; none were used this month. Services of $2,500 were performed this month on credit. Services were performed for $10,000 cash...
Question#6 Nickolas Imports recorded a restructuring charge of $21.6 million during fiscal 2014 related entirely to...
Question#6 Nickolas Imports recorded a restructuring charge of $21.6 million during fiscal 2014 related entirely to the closing of its California based operations in San Diego and in Tijuana, Mexico. The company’s financial statement footnotes indicated that expected employee separation payments amounted to $16.8 million and that fixed asset write-downs accounted for the remainder. Nickolas had never before incurred restructuring charges. At the end of the year, the company’s balance sheet included a restructuring accrual of $3,600,000. Required: Use the...
Inferring Transactions from Financial Statements Lowe's is the second-largest home improvement retailer in the world, with...
Inferring Transactions from Financial Statements Lowe's is the second-largest home improvement retailer in the world, with 1,857 stores. During its 2015 fiscal year ended in January 2016, Lowe's purchased merchandise inventory at a cost of $39,051 ($ millions). Assume all purchases were made on account and accounts payable is only used for inventory purchases. The following T-accounts reflect information contained in the company's 2014 and 2015 balance sheets. Merchandise Inventories 2014 Bal. 8,911 2015 Bal. 9,458 Accounts Payable 5,124 2014...
Inferring Transactions from Financial Statements The GAP is a global clothing retailer for men, women, children,...
Inferring Transactions from Financial Statements The GAP is a global clothing retailer for men, women, children, and babies. The following information is taken from The Gap's fiscal 2015 annual report. Selected Balance Sheet Data ($ millions) 2015 2014 Inventories $1,901 $1,861 Accounts Payable 1,140 1,145 a. The Gap purchased inventories totaling $10,314 million during fiscal 2015. Use the financial statement effects template to record cost of goods sold for The Gap's fiscal year ended 2015. (Assume accounts payable is used...
Analyzing and Reporting Financial Statement Effects of Bond Transactions Lundholm, Inc., reports financial statements each December...
Analyzing and Reporting Financial Statement Effects of Bond Transactions Lundholm, Inc., reports financial statements each December 31 and issues $500,000, 9%, 15-year bonds dated May 1, 2012, with interest payments on October 31 and April 30. Assuming the bonds are sold at par on May 1, 2012, complete the financial statement effects template to reflect the following events: (a) bond issuance, (b) the first semiannual interest payment, and (c) retirement of $300,000 of the bonds at 101 on November 1,...
Reporting Financial Statement Effects of Bond Transactions On January 1, 2016, McKeown, Inc., issued $350,000 of...
Reporting Financial Statement Effects of Bond Transactions On January 1, 2016, McKeown, Inc., issued $350,000 of 12%, 9-year bonds for $314,792, yielding a market (yield) rate of 14%. Semiannual interest is payable on June 30 and December 31 of each year. Required a. Show computations to confirm the bond issue price. (Use a calculator or Excel for your calculations. Round your answers to the nearest dollar.) Present value of principal repayment $Answer Present value of interest payments $Answer Selling price...
Reporting Financial Statement Effects of Bond Transactions On January 1, 2016, McKeown, Inc., issued $300,000 of...
Reporting Financial Statement Effects of Bond Transactions On January 1, 2016, McKeown, Inc., issued $300,000 of 6%, 9-year bonds for $262,023, yielding a market (yield) rate of 8%. Semiannual interest is payable on June 30 and December 31 of each year. Required a. Show computations to confirm the bond issue price. (Use a calculator or Excel for your calculations. Round your answers to the nearest dollar.) Present value of principal repayment $Answer Present value of interest payments $Answer Selling price...
Analyzing and Reporting Financial Statement Effects of Transactions M.E. Carter launched Carter Company, a professional services...
Analyzing and Reporting Financial Statement Effects of Transactions M.E. Carter launched Carter Company, a professional services firm on March 1. The firm will prepare financial statements at each month-end. In March (its first month), Carter executed the following transactions. Enter the transactions, a through g, into the financial statement effects template below. a. Carter (owner) invested in the company $200,000 cash and $40,000 in property and equipment. The company issued common stock to Carter. b. The company paid $6,400 cash...
The stockholders’ equity of Palepu Company at December 31, 2015, appears below. Common stock, $12 par...
The stockholders’ equity of Palepu Company at December 31, 2015, appears below. Common stock, $12 par value, 200,000 shares authorized; 82,000 shares issued and outstanding $984,000 Paid-in capital in excess of par value 480,000 Retained earnings 305,000 During 2016, the following transactions occurred: May 12 Declared and issued a 4% stock dividend; the common stock market value was $18 per share. Dec. 31 Declared and paid a cash dividend of 75 cents per share. a. Using the financial statement effects...
Reporting of and Analyzing Financial Effects of Available-for-Sale (Equity) Securities Guay Company had the following transactions...
Reporting of and Analyzing Financial Effects of Available-for-Sale (Equity) Securities Guay Company had the following transactions and adjustment related to a stock investment classified as a trading security. Assume that when the shares were purchased, management did not intend to sell the stock in the near future. Record the transactions and adjustments for Guay Company under this assumption. 2015 Nov. 15 Purchased 6,000 shares of Core, Inc.'s common stock at $16 per share plus a brokerage commission of $900. Guay...