Following are selected account balances (in millions of dollars) from a recent UPS annual report, followed by several typical transactions. Assume that the following are account balances on December 31 (end of the prior fiscal year): Account Property, plant, and equipment (net) Retained earnings Accounts payable Prepaid expenses Accrued expenses payable Long-term notes payable Other non-current assets Common stock ($0.01 par value) Balance $14,094 Receivables 9,806 Other current assets. 1,277 Cash 118 Spare parts, supplies, and fuel 2,090 Other non-current liabilities 1,510 Other current liabilities 2,582 Additional Paid-in Capital 2 Account Balance f. Repaid $160 on a long-term note (ignore interest). g. Issued 200 million additional shares of $0.01 par value stock for $17 (that's $17 million). h. Paid employees $9,526 for work during the year. i. Purchased spare parts, supplies, and fuel for the aircraft and equipment for $6,864 cash. $1,599 889 904 415 These accounts are not necessarily in good order and have normal debit or credit balances. (Note: Because these are not all of UPS's accounts, these will not balance in a trial balance.) Assume the following transactions (in millions, except for par value) occurred the next fiscal year beginning January 1 (the current year): 3,320 1,959 637 a. Provided delivery service to customers, who paid $1,890 in cash and owed $25,104 on account. b. Purchased new equipment costing $3,454; signed a long-term note. c. Paid $8,064 cash to rent equipment and aircraft, with $3,286 for rent this year and the rest for rent next year (a prepaid expense). d. Spent $884 cash to repair facilities and equipment during the year. e. Collected $24,885 from customers on account. 3. Prepare an unadjusted income statement for the current year ended December 31. 4. Compute the company's net profit margin ratio for the current year ended December 31. j. Used $6,500 in spare parts, supplies, and fuel for the aircraft and equipment during the year. k. Paid $804 on accounts payable. I. Ordered $90 in spare parts and supplies. Required: 1. Prepare journal entries for each transaction. 2. Enter the ending balances from December 31 as the respective beginning balances for January 1 of the current year. Record in the T-accounts the effects of each transaction. Label each using the letter of the transaction.

Managerial Accounting
15th Edition
ISBN:9781337912020
Author:Carl Warren, Ph.d. Cma William B. Tayler
Publisher:Carl Warren, Ph.d. Cma William B. Tayler
Chapter16: Financial Statement Analysis
Section: Chapter Questions
Problem 13E: Ratio of liabilities to stockholders equity and times interest earned The following data were taken...
icon
Related questions
icon
Concept explainers
Topic Video
Question

Hello, can I have help with creating a journal entry, ending balances, income statement, and net profit ratio?

Following are selected account balances (in millions of dollars) from a recent UPS annual report, followed by several typical
transactions. Assume that the following are account balances on December 31 (end of the prior fiscal year):
Account
Property, plant, and equipment (net)
Retained earnings
Accounts payable
Prepaid expenses
Accrued expenses payable
Long-term notes payable
Other non-current assets
Common stock ($0.01 par value)
Balance
$14,094 Receivables
9,806
1,277
118
2,090
1,510
2,582
2
Account
Other current assets
Cash
Spare parts, supplies, and fuel
Other non-current liabilities
Other current liabilities
Additional Paid-in Capital
Balance
$1,599
889
904
415
These accounts are not necessarily in good order and have normal debit or credit balances. (Note: Because these are not all of UPS's
accounts, these will not balance in a trial balance.) Assume the following transactions (in millions, except for par value) occurred the
next fiscal year beginning January 1 (the current year):
f. Repaid $160 on a long-term note (ignore interest).
g. Issued 200 million additional shares of $0.01 par value stock for $17 (that's $17 million).
3,320
1,959
637
a. Provided delivery service to customers, who paid $1,890 in cash and owed $25,104 on account.
b. Purchased new equipment costing $3,454; signed a long-term note.
c. Paid $8,064 cash to rent equipment and aircraft, with $3,286 for rent this year and the rest for rent next year (a prepaid expense).
d. Spent $884 cash to repair facilities and equipment during the year.
e. Collected $24,885 from customers on account.
h. Paid employees $9,526 for work during the year.
i. Purchased spare parts, supplies, and fuel for the aircraft and equipment for $6,864 cash.
j. Used $6,500 in spare parts, supplies, and fuel for the aircraft and equipment during the year.
k. Paid $804 on accounts payable.
I. Ordered $90 in spare parts and supplies.
Required:
1. Prepare journal entries for each transaction.
2. Enter the ending balances from December 31 as the respective beginning balances for January 1 of the current year. Record in the
T-accounts the effects of each transaction. Label each using the letter of the transaction.
3. Prepare an unadjusted income statement for the current year ended December 31.
4. Compute the company's net profit margin ratio for the current year ended December 31.
Transcribed Image Text:Following are selected account balances (in millions of dollars) from a recent UPS annual report, followed by several typical transactions. Assume that the following are account balances on December 31 (end of the prior fiscal year): Account Property, plant, and equipment (net) Retained earnings Accounts payable Prepaid expenses Accrued expenses payable Long-term notes payable Other non-current assets Common stock ($0.01 par value) Balance $14,094 Receivables 9,806 1,277 118 2,090 1,510 2,582 2 Account Other current assets Cash Spare parts, supplies, and fuel Other non-current liabilities Other current liabilities Additional Paid-in Capital Balance $1,599 889 904 415 These accounts are not necessarily in good order and have normal debit or credit balances. (Note: Because these are not all of UPS's accounts, these will not balance in a trial balance.) Assume the following transactions (in millions, except for par value) occurred the next fiscal year beginning January 1 (the current year): f. Repaid $160 on a long-term note (ignore interest). g. Issued 200 million additional shares of $0.01 par value stock for $17 (that's $17 million). 3,320 1,959 637 a. Provided delivery service to customers, who paid $1,890 in cash and owed $25,104 on account. b. Purchased new equipment costing $3,454; signed a long-term note. c. Paid $8,064 cash to rent equipment and aircraft, with $3,286 for rent this year and the rest for rent next year (a prepaid expense). d. Spent $884 cash to repair facilities and equipment during the year. e. Collected $24,885 from customers on account. h. Paid employees $9,526 for work during the year. i. Purchased spare parts, supplies, and fuel for the aircraft and equipment for $6,864 cash. j. Used $6,500 in spare parts, supplies, and fuel for the aircraft and equipment during the year. k. Paid $804 on accounts payable. I. Ordered $90 in spare parts and supplies. Required: 1. Prepare journal entries for each transaction. 2. Enter the ending balances from December 31 as the respective beginning balances for January 1 of the current year. Record in the T-accounts the effects of each transaction. Label each using the letter of the transaction. 3. Prepare an unadjusted income statement for the current year ended December 31. 4. Compute the company's net profit margin ratio for the current year ended December 31.
Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 4 steps with 3 images

Blurred answer
Knowledge Booster
Financial Statements
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, accounting and related others by exploring similar questions and additional content below.
Similar questions
Recommended textbooks for you
Managerial Accounting
Managerial Accounting
Accounting
ISBN:
9781337912020
Author:
Carl Warren, Ph.d. Cma William B. Tayler
Publisher:
South-Western College Pub
Financial And Managerial Accounting
Financial And Managerial Accounting
Accounting
ISBN:
9781337902663
Author:
WARREN, Carl S.
Publisher:
Cengage Learning,
Financial Accounting
Financial Accounting
Accounting
ISBN:
9781337272124
Author:
Carl Warren, James M. Reeve, Jonathan Duchac
Publisher:
Cengage Learning
Managerial Accounting: The Cornerstone of Busines…
Managerial Accounting: The Cornerstone of Busines…
Accounting
ISBN:
9781337115773
Author:
Maryanne M. Mowen, Don R. Hansen, Dan L. Heitger
Publisher:
Cengage Learning
Financial Accounting
Financial Accounting
Accounting
ISBN:
9781305088436
Author:
Carl Warren, Jim Reeve, Jonathan Duchac
Publisher:
Cengage Learning
Financial Accounting: The Impact on Decision Make…
Financial Accounting: The Impact on Decision Make…
Accounting
ISBN:
9781305654174
Author:
Gary A. Porter, Curtis L. Norton
Publisher:
Cengage Learning