Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Silver Titan's company has projected sales for the first seven months of 2021 are given below: Month January February March April May June July Amount

image text in transcribed

Silver Titan's company has projected sales for the first seven months of 2021 are given below: Month January February March April May June July Amount $250,000 $340,000 $280,000 $300,000 $350,000 $380,000 $300,000 . . . Monthly salary is $35,000 per month. Total other cash expenses are $90,000/month. The company's cash balance as of March 31, 2021, will be $30,000. Excess cash will be used to retire short-term borrowing (if any). Cost of goods sold is 50% of sales. Purchases and payments are made in the month prior to the sales. Silver Titan's company has no short-term borrowing as of March 31, 2021. Short term loan can be obtained in the end of each month at 12% annual interest with interest paid in the following month for which the loan is outstanding. 30% of sales are collected in cash at time of sale, 50% are collected in the month following the sale, and the remaining 20% are collected in the second month following the sale. Silver Titan's company must have a minimum cash balance of $25,000 at the beginning of each month. Silver Titan's company plans to buy an equipment worth $20,000 in the month of May 2021. Prepare the cash budget for the second quarter of 2021

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image_2

Step: 3

blur-text-image_3

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Fundamental Accounting Principles Volume 2

Authors: John Wild, Ken Shaw, Barbara Chiappetta

21st Edition

0077716663, 978-0077716660

More Books

Students also viewed these Accounting questions

Question

Carry out the details of the proof of Theorem 1.

Answered: 1 week ago

Question

Why do you think most employers opt for the home-based salary plan?

Answered: 1 week ago