FINANCIAL ACCOUNTING
10th Edition
ISBN: 9781259964947
Author: Libby
Publisher: MCG
expand_more
expand_more
format_list_bulleted
Related questions
Question
Polar Company purchased a Truck for the company use. The price was $48,000 plus 7% sales taxes.
Company paid $5,000 in cash and signed a 4.75% note that requires 40 equal monthly payment at the
end of each month for the rest. Provide answer to the following question on the Tab named Financial
Accounting on the Excel file.
Requirement:
a) Provide the
b) Determine the amount of monthly payment that must be made.
c) Prepare Amortization Schedule.
d) Provide the journal entry that company must make the for 2nd monthly payment.
e) Provide the journal entry that company must make on the last monthly payment.
Problem 5. Excel Sheet Formatting for Data Entry
Elizabet wants to use the Excel Sheet in Tab called “Formatting” for compiling and recording
company sales. You have been asked to help her in formatting the sheet in order (a) to reduce the
chance of errors in typing, and (b) speedup data entry. Elizabet only will be typing the value for “Tran
Date”, “Product No.”, and “Quantity Sold” highlighted in yellow.
Do the Followings
1. On Column B, under “Month of Sale”, write the necessary formula for splitting the transaction
date and showing the Month of Sale. This field will be needed for future Pivot Table
preparation.
2. On Column C, under “Salesperson”, using the Salespersons Table on cell K12, develop a pull-
down menu that will show the names of salesperson for selection rather than to be typed.
Expert Solution
This question has been solved!
Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.
Step by stepSolved in 5 steps with 7 images
Knowledge Booster
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
- 7. AB Company purchases a truck in the amount of $15,000. Additional costs include sales tax of $1500, painting of $2500, license of $150 and a 1 year auto insurance policy of $1200. Complete the journal entry for the auto purchase. Account Debit Credit Truck 20,350 Cash 20,350arrow_forwardThe following transactions apply to Ozark Sales for Year 1: The business was started when the company received $50,000 from the issue of common stock. Purchased equipment inventory of $178,000 on account. Sold equipment for $192,000 cash (not including sales tax). Sales tax of 6 percent is collected when the merchandise is sold. The merchandise had a cost of $117,000. Provided a six-month warranty on the equipment sold. Based on industry estimates, the warranty claims would amount to 5 percent of sales. Paid the sales tax to the state agency on $142,000 of the sales. On September 1, Year 1, borrowed $21,500 from the local bank. The note had a 6 percent interest rate and matured on March 1, Year 2. Paid $5,900 for warranty repairs during the year. Paid operating expenses of $56,000 for the year. Paid $124,000 of accounts payable. Recorded accrued interest on the note issued in transaction no. 6. Required Record the given transactions in a horizontal statements model. Prepare the…arrow_forwardSentry Transport Inc. of Atlanta provides in-town parcel delivery services in addition to a fullrange of passenger services. Sentry engaged in the following activities during the current year:a. Sentry received $5,000 cash in advance from Rich’s Department Store for an estimated 250deliveries during December 2019 and January and February of 2020. The entire amountwas recorded as unearned revenue when received. During December 2019, 110 deliverieswere made for Rich’s.b. Sentry operates several small buses that take commuters from suburban communities to thecentral downtown area of Atlanta. The commuters purchase, in advance, tickets for 50 onewayrides. Each 50-ride ticket costs $500. At the time of purchase, Sentry credits the cashreceived to unearned revenue. At year end, Sentry determines that 10,160 one-way rideshave been taken.c. Sentry operates several buses that provide transportation for the clients of a social service agencyin Atlanta. Sentry bills the agency quarterly at the…arrow_forward
- The following transactions apply to Ozark Sales for Year 1: The business was started when the company received $50,000 from the issue of common stock. Purchased equipment inventory of $178,000 on account. Sold equipment for $192,000 cash (not including sales tax). Sales tax of 6 percent is collected when the merchandise is sold. The merchandise had a cost of $117,000. Provided a six-month warranty on the equipment sold. Based on industry estimates, the warranty claims would amount to 5 percent of sales. Paid the sales tax to the state agency on $142,000 of the sales. On September 1, Year 1, borrowed $21,500 from the local bank. The note had a 6 percent interest rate and matured on March 1, Year 2. Paid $5,900 for warranty repairs during the year. Paid operating expenses of $56,000 for the year. Paid $124,000 of accounts payable. Recorded accrued interest on the note issued in transaction no. 6. Required Record the given transactions in a horizontal statements model. Prepare the…arrow_forwardState the accounting entries required if a business made sales on credit of $10,000, on which it must account for sales tax at the rate of 20%.arrow_forwardScrimiger Paints wants to upgrade its machinery and on September 20 takes out a loan from the bank in the amount of $670,000. The terms of the loan are 3.8% annual interest rate and payable in 8 months. Interest is due in equal payments each month. A. Compute the interest expense due each month. If required, round final answer to two decimal places. B. Show the journal entry to recognize the interest payment on October 20, and the entry for payment of the short-term note and final interest payment on May 20. If required, round final answers to two decimal places. If an amount box does not require an entry, leave it blank. Oct. 20 May 20arrow_forward
- Journalize the following entries on the books of the borrower and creditor. Label accordingly. (Assume a 360-day year is used for interest calculations.) June 1 James Co. purchased merchandise on account from O’Leary Co., $90,000, terms n/30. The cost of merchandise sold was $54,000. 30 James Co. issued a 60-day, 5% note for $90,000 on account. Aug. 29 James Co. paid the amount due.arrow_forwardArevalo Machinery Company sold a custom production mill for $480,000, receiving a $60,000 down payment and a 12% note for the balance. The journal entry to record this sale would include a: Group of answer choices Debit to note receivable. Credit to note receivable. Credit to cash. Debit to cash discount.arrow_forward
arrow_back_ios
arrow_forward_ios
Recommended textbooks for you
AccountingAccountingISBN:9781337272094Author:WARREN, Carl S., Reeve, James M., Duchac, Jonathan E.Publisher:Cengage Learning,
Accounting Information SystemsAccountingISBN:9781337619202Author:Hall, James A.Publisher:Cengage Learning,
Horngren's Cost Accounting: A Managerial Emphasis...AccountingISBN:9780134475585Author:Srikant M. Datar, Madhav V. RajanPublisher:PEARSON
Intermediate AccountingAccountingISBN:9781259722660Author:J. David Spiceland, Mark W. Nelson, Wayne M ThomasPublisher:McGraw-Hill Education
Financial and Managerial AccountingAccountingISBN:9781259726705Author:John J Wild, Ken W. Shaw, Barbara Chiappetta Fundamental Accounting PrinciplesPublisher:McGraw-Hill Education
Accounting
Accounting
ISBN:9781337272094
Author:WARREN, Carl S., Reeve, James M., Duchac, Jonathan E.
Publisher:Cengage Learning,
Accounting Information Systems
Accounting
ISBN:9781337619202
Author:Hall, James A.
Publisher:Cengage Learning,
Horngren's Cost Accounting: A Managerial Emphasis...
Accounting
ISBN:9780134475585
Author:Srikant M. Datar, Madhav V. Rajan
Publisher:PEARSON
Intermediate Accounting
Accounting
ISBN:9781259722660
Author:J. David Spiceland, Mark W. Nelson, Wayne M Thomas
Publisher:McGraw-Hill Education
Financial and Managerial Accounting
Accounting
ISBN:9781259726705
Author:John J Wild, Ken W. Shaw, Barbara Chiappetta Fundamental Accounting Principles
Publisher:McGraw-Hill Education