Question

In: Accounting

Plum Corporation began the month of May with $800,000 of current assets, a current ratio of...

Plum Corporation began the month of May with $800,000 of current assets, a current ratio of 2.00:1, and an acid-test ratio of 1.30:1. During the month, it completed the following transactions (the company uses a perpetual inventory system).

May 2 Purchased $75,000 of merchandise inventory on credit.
8 Sold merchandise inventory that cost $65,000 for $145,000 cash.
10 Collected $30,000 cash on an account receivable.
15 Paid $27,500 cash to settle an account payable.
17 Wrote off a $5,000 bad debt against the Allowance for Doubtful Accounts account.
22 Declared a $1 per share cash dividend on its 56,000 shares of outstanding common stock.
26 Paid the dividend declared on May 22.
27 Borrowed $95,000 cash by giving the bank a 30-day, 10% note.
28 Borrowed $105,000 cash by signing a long-term secured note.
29 Used the $200,000 cash proceeds from the notes to buy new machinery.


Required:
Complete the table below showing Plum's (1) current ratio, (2) acid-test ratio, and (3) working capital after each transaction. (Do not round intermediate calculations. Round your ratios to 2 decimal places and the working capitals to nearest dollar amount. Subtracted amount should be indicated with a minus sign.)

Transaction Current Assets Quick Assets Current Liabilities Current Ratio Acid-Test Ratio Working Capital
Beginning $800,000 $520,000 $400,000 2.00 1.30 $400,000
May 2
Balance 800,000 400,000
May 8
Balance
May 10
Balance
May 15
Balance
May 17
Balance
May 22
Balance
May 26
Balance
May 27
Balance
May 28
Balance
May 29
Balance

Solutions

Expert Solution

Required ratios are as calculated below:

Current assets (a) Inventory and Prepaid Expenses Current assets- prepaid-Inventory = b Current Liabilities = c Current ratio = a/c Acid Test ratio (b/c Working capital a-c
May-01 800,000 280,000 520,000 400,000 2.00 1.30 400,000
May-02 75,000 75,000 0 75,000
Balance 875,000 355,000 520,000 475,000 1.84 1.09 400,000
May-08 145,000 145,000
-65,000 -65,000 0
Balance 955,000 290,000 665,000 475,000 2.01 1.40 480,000
May-10 30,000 30,000
-30,000 -30,000
Balance 955,000 290,000 665,000 475,000 2.01 1.40 480,000
May-15 -27,500 -27,500 -27,500
Balance 927,500 290,000 637,500 447,500 2.07 1.42 480,000
May-17 0 5,000
Balance 927,500 290,000 637,500 452,500 2.05 1.41 475,000
May-22 0 56,000
Balance 927,500 290,000 637,500 508,500 1.82 1.25 419,000
May-26 -56,000 -56,000 -56,000
Balance 871,500 290,000 581,500 452,500 1.93 1.29 419,000
May-27 95,000 95,000 95,000
Balance 966,500 290,000 676,500 547,500 1.77 1.24 419,000
May-28 105,000 105,000
Balance 1,071,500 290,000 781,500 547,500 1.96 1.43 524,000
May-29 -200,000 -200,000
Balance 871,500 290,000 581,500 547,500 1.59 1.06 324,000

Related Solutions

Plum Corporation began the month of May with $1,200,000 of current assets, a current ratio of...
Plum Corporation began the month of May with $1,200,000 of current assets, a current ratio of 2.20:1, and an acid-test ratio of 1.20:1. During the month, it completed the following transactions (the company uses a perpetual inventory system). May 2 Purchased $75,000 of merchandise inventory on credit. 8 Sold merchandise inventory that cost $60,000 for $140,000 cash. 10 Collected $31,000 cash on an account receivable. 15 Paid $28,000 cash to settle an account payable. 17 Wrote off a $5,000 bad...
Plum Corporation began the month of May with $700,000 of current assets, a current ratio of...
Plum Corporation began the month of May with $700,000 of current assets, a current ratio of 1.80:1, and an acid-test ratio of 1.50:1. During the month, it completed the following transactions (the company uses a perpetual inventory system).   May 2 Purchased $60,000 of merchandise inventory on credit. 8 Sold merchandise inventory that cost $55,000 for $135,000 cash. 10 Collected $26,000 cash on an account receivable. 15 Paid $27,500 cash to settle an account payable. 17 Wrote off a $5,000 bad...
Hitaki Sales Inc. began the month of July with $562,500 of current assets, a current ratio...
Hitaki Sales Inc. began the month of July with $562,500 of current assets, a current ratio of 2.25:1, and an acid-test ratio of 1.00:1. During the month, it completed the following transactions (the company uses a perpetual inventory system). (PLEASE SHOW SOME OF YOUR WORK SO IT IS EASIER TO FOLLOW, THANK YOU) July      3        Purchased $67,500 of merchandise inventory on credit.             10        Sold merchandise inventory that cost $75,000 for $120,000 cash.             12        Collected $40,000 cash on an...
)   Hitaki Sales Inc. began the month of July with $562,500 of current assets, a current...
)   Hitaki Sales Inc. began the month of July with $562,500 of current assets, a current ratio of 2.25:1, and an acid-test ratio of 1.00:1. During the month, it completed the following transactions (the company uses a perpetual inventory system). (50 points) July   3   Purchased $67,500 of merchandise inventory on credit.    10   Sold merchandise inventory that cost $75,000 for $120,000 cash.    12   Collected $40,000 cash on an account receivable.    14   Paid $32,000 cash to settle an account...
The current ratio looks at the current liabilities versus current assets. Why is this ratio important...
The current ratio looks at the current liabilities versus current assets. Why is this ratio important and why not look at total liabilities versus total assets? What is the current ratio telling us?
1. Quick Ratio= current assets-inventories/ current liabilities 2. Debt to Assets ratio= total debt/total assets 3....
1. Quick Ratio= current assets-inventories/ current liabilities 2. Debt to Assets ratio= total debt/total assets 3. Earnings Per Share (EPS)=total earnings/outstanding shares (must first solve net income-preferred divideneds= total earnings) 4. Net Income (Net profit)=total revenues-total expenses I need help finding the answer to these equations for Target Corporation for 2015 and 2016. please refer to the links for the 10k reports for the company. 2015- https://corporate.target.com/_media/TargetCorp/annualreports/2015/pdfs/Target-2015-Annual-Report.pdf 2016- https://corporate.target.com/_media/TargetCorp/annualreports/2016/pdfs/Target-2016-Annual-Report.pdf?ext=.pdf
What assets are not in the Quick Ratio that are in the Current Ratio? What makes...
What assets are not in the Quick Ratio that are in the Current Ratio? What makes these assets different? Please explain
CURRENT RATIO What is the formula? Current assets/current liabilities pg 51 Calculate the ratio current year....
CURRENT RATIO What is the formula? Current assets/current liabilities pg 51 Calculate the ratio current year. Page________ 7266/10132=.72 Calculate the ratio for the prior year. Page_______ 8753/9501=.92 Analyze the ratio trend. 2. RETURN ON ASSETS What is the formula? net income/avg total assets Calculate the ratio current year. 10990/((120,232)=9.15% Page_______19_ Calculate the ratio for the prior year. Page_______ 3642/(120,480)=3.02% Analyze the ratio trend. 3. RECEIVABLE TURNOVER RATIO What is the formula?Net credit Sales/Average Account Receivable Calculate the ratio current year....
Distinguish between fixed and current assets and describe current ratio.
Distinguish between fixed and current assets and describe current ratio.
A firm has $200,000 in current assets, $800,000 in long-term assets and $900,000 in long-term financing....
A firm has $200,000 in current assets, $800,000 in long-term assets and $900,000 in long-term financing. What is its net working capital (CA -CL)? Hint: Prepare a Balance Sheet.
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT