Assignment: Financial Accounting

profilemcyrayvahgr
Copyofcf_Unit2_P3-4.xlsx

P3-4

P3-4 Analyzing the Effects of Transactions Using T-Accounts, Preparing an Income Statement, and Evaluating the Net Profit Margin Ratio as a Manager LO3-4, 3-5, 3-6
Kaylee James, a connoisseur of fine chocolate, opened Kaylee’s Sweets in Collegetown on February 1, 2014. The shop specializes in a selection of gourmet chocolate
candies and a line of gourmet ice cream. You have been hired as manager. Your duties include maintaining the store’s financial records. The following
transactions occurred in February 2014, the first month of operations.
a. Received four shareholders’ contributions totaling $30,200 cash to form the corporation; issued 400 shares of $.10 par value common stock.
b. Paid three months' rent for the store at $1,750 per month (recorded as prepaid expenses).
c. Purchased and received candy for $6,000 on account, due in 60 days.
d. Purchased supplies for $1,560 cash.
e. Negotiated and signed a two-year $11,000 loan at the bank.
f. Used the money from (e) to purchase a computer for $2,750 (for recordkeeping and inventory tracking); used the balance for furniture and fixtures for the store.
g. Placed a grand opening advertisement in the local paper for $400 cash; the ad ran in the current month.
h. Made sales on Valentine's Day totaling $3,500; $2,675 was in cash and the rest on accounts receivable. The cost of the candy sold was $1,600.
i. Made a $550 payment on accounts payable.
j. Incurred and paid employee wages of $1,300.
k. Collected accounts receivable of $600 from customers.
l. Made a repair to one of the display cases for $400 cash.
m. Made cash sales of $1,200 during the rest of the month. The cost of the candy sold was $600.
Required:
1 & 2. Record in the T-accounts the effects of each transaction for Kaylee’s Sweets in February, referencing each transaction in the accounts with the transaction
letter. Show the ending balances in the T-accounts. An example amount has been posted to the Cash T-Account from transaction (l).
Cash Accounts Receivable
Beg. bal. Beg. bal.
400 (l)
End. bal.
End. bal. 400
Supplies Inventory
Beg. bal. Beg. bal.
End. bal. End. bal.
Prepaid Expenses Equipment
Beg. bal. Beg. bal.
End. bal. End. bal.
Furniture and Fixtures Accounts Payable
Beg. bal. Beg. bal.
End. bal. End. bal.
Notes Payable Common Stock
Beg. bal. Beg. bal.
End. bal. End. bal.
Additional Paid-in Capital Sales Revenue
Beg. bal. Beg. bal.
End. bal. End. bal.
Cost of Goods Sold Repair Expense
Beg. bal. Beg. bal.
End. bal.
End. bal.
Advertising Expense Wage Expense
Beg. bal. Beg. bal.
End. bal. End. bal.
Required:
3 Prepare an income statement at the end of the month ended February 28, 2014.
KAYLEE’S SWEETS
Income Statement (unadjusted)
For the Month Ended February 28, 2014
Revenues:
Expenses:
Total cost and expenses -
Required:
5 After three years in business, you are being evaluated for a promotion. One measure is how effectively you managed the sales and expenses of the business.
    The following data are available:
 2016*   2015   2014
  Total assets $ 88,000 $ 58,500 $ 52,500
  Total liabilities 49,500 22,000 18,500
  Total stockholders’ equity 38,500 36,500 34,000
  Net sale revenue 93,500 82,500 55,000
  Net income 22,000 11,000 4,400
* At the end of 2016, Kaylee decided to open a second store, requiring loans and inventory
purchases prior to the store’s opening in early 2017.
5-a. Calculate the net profit margin ratio for each year. (Round your answers to 1 decimal place.)
Net Profit Margin Ratio
2016 %
2015 %
2014 %
5-b. Do you think you should be promoted?

YES

NO

P3-4 Check Figures

P3-4 Analyzing the Effects of Transactions Using T-Accounts, Preparing an Income Statement, and Evaluating the Net Profit Margin Ratio as a Manager LO3-4, 3-5, 3-6
Kaylee James, a connoisseur of fine chocolate, opened Kaylee’s Sweets in Collegetown on February 1, 2014. The shop specializes in a selection of gourmet chocolate
candies and a line of gourmet ice cream. You have been hired as manager. Your duties include maintaining the store’s financial records. The following
transactions occurred in February 2014, the first month of operations.
a. Received four shareholders’ contributions totaling $30,200 cash to form the corporation; issued 400 shares of $.10 par value common stock.
b. Paid three months' rent for the store at $1,750 per month (recorded as prepaid expenses).
c. Purchased and received candy for $6,000 on account, due in 60 days.
d. Purchased supplies for $1,560 cash.
e. Negotiated and signed a two-year $11,000 loan at the bank.
f. Used the money from (e) to purchase a computer for $2,750 (for recordkeeping and inventory tracking); used the balance for furniture and fixtures for the store.
g. Placed a grand opening advertisement in the local paper for $400 cash; the ad ran in the current month.
h. Made sales on Valentine's Day totaling $3,500; $2,675 was in cash and the rest on accounts receivable. The cost of the candy sold was $1,600.
i. Made a $550 payment on accounts payable.
j. Incurred and paid employee wages of $1,300.
k. Collected accounts receivable of $600 from customers.
l. Made a repair to one of the display cases for $400 cash.
m. Made cash sales of $1,200 during the rest of the month. The cost of the candy sold was $600.
Required:
1 & 2. Record in the T-accounts the effects of each transaction for Kaylee’s Sweets in February, referencing each transaction in the accounts with the transaction
letter. Show the ending balances in the T-accounts. An example amount has been posted to the Cash T-Account from transaction (l).
Cash Accounts Receivable
Beg. bal. Beg. bal.
400 (l)
End. bal.
End. bal.
Supplies Inventory
Beg. bal. Beg. bal.
End. bal. End. bal.
Prepaid Expenses Equipment
Beg. bal. Beg. bal.
End. bal. End. bal.
Furniture and Fixtures Accounts Payable
Beg. bal. Beg. bal.
End. bal. End. bal.
Notes Payable Common Stock
Beg. bal. Beg. bal.
End. bal. End. bal.
Additional Paid-in Capital Sales Revenue
Beg. bal. Beg. bal.
End. bal. End. bal.
Cost of Goods Sold Repair Expense
Beg. bal. Beg. bal.
End. bal.
End. bal.
Advertising Expense Wage Expense
Beg. bal. Beg. bal.
End. bal. End. bal.
Required:
3 Prepare an income statement at the end of the month ended February 28, 2014.
KAYLEE’S SWEETS
Income Statement (unadjusted)
For the Month Ended February 28, 2014
Revenues:
Expenses:
Total cost and expenses 0
Net income $400
Required:
5 After three years in business, you are being evaluated for a promotion. One measure is how effectively you managed the sales and expenses of the business.
    The following data are available:
 2016*   2015   2014
  Total assets $ 88,000   $ 58,500   $ 52,500  
  Total liabilities 49,500   22,000   18,500  
  Total stockholders’ equity 38,500   36,500   34,000  
  Net sale revenue 93,500   82,500   55,000  
  Net income 22,000   11,000   4,400  
* At the end of 2016, Kaylee decided to open a second store, requiring loans and inventory
purchases prior to the store’s opening in early 2017.
5-a. Calculate the net profit margin ratio for each year. (Round your answers to 1 decimal place.)
Net Profit Margin Ratio
2016 %
2015 %
2014 %
5-b. Do you think you should be promoted?

YES

NO

Sheet2

List 1 21 12
(a) Net income Accounts payable
(b) Net loss Accounts receivable
(c) Additional paid-in-capital
(d) Advertising expense
(e) Cash
(f) Commission expense
(g) Common stock
(h) Consulting expense
(i) Cost of goods sold
(j) Equipment
(k) Fuel expense
(l) Games revenue
(m) Insurance expense
Interest expense
Interest revenue
Inventory
Land
Miscellaneous expenses
Notes payable (long-term)
Notes payable (short-term)
Prepaid expenses
Rent expense
Rent revenue
Repair expense
Retained earnings
Sales revenue
Supplies
Supplies expense
Unearned revenue
Utilities expense
Wage expense
Wages payable