Prepare a spreadsheet

Burkhart Enterprises wants you to prepare a spreadsheet to answer the following questions:

A. Purchases (net of discount) of inventory were $500,000 during the period. The beginning balance of accounts payable was $40,000, while the ending balance was $25,000. A purchase of $4,000 (net) was returned during the period. How much cash was paid for inventory during the period?

B. Cash paid for inventory during the period was $400,000. The beginning and ending balances of accounts payable were $10,000 and $12,000, respectively. Cash discounts of $2,500 were lost during the period. No purchase returns were made during the year. What was the amount of purchases (net of discount) made during the period? (Hint: When cash discounts are lost, cash decreases by more than accounts payable.)

C. Purchases of inventory (net of discount) were $800,000, while cash paid for inventory was $950,000 during the period. A purchase of $5,000 (net) was returned during the period. If the ending balance of accounts payable was $35,000, what was the beginning balance?

Solution:

Looking for help with your homework?
Grab a 30% Discount and Get your paper done!

30% OFF
Turnitin Report
Formatting
Title Page
Citation
Place an Order

Grab A 14% Discount on This Paper
Pages (550 words)
Approximate price: -