2. Given the information below.create a cah bodget Worksheet 21: Cash Budgets Sales January February...

50.1K

Verified Solution

Question

Finance

image
2. Given the information below.create a cah bodget Worksheet 21: Cash Budgets Sales January February 1. Given the information below, complete the cash budget O Caal badet February March Sales $150 000 $200 000 10,000 3.000 5.000 10,000 5.000 3.000 April May June April $250.000 530.000 520,000 580.000 Cash Collections Other reset Totalcash Salaris Other debuerats Toallashdistuneet Net change dumt the south 60% of sales me on credit and are collected after one month Wages are 60% of sales Monthly fixed costs are $1.000 In March, the firm receives $2.000 from a bood that matures Taxes of $2,000 me due in April and in June The firm desires a cash balance of $1,500 at all times Beginning cash is $1,500 I Collections occur ce month after the sale January's credit sales were $80,000 The firm as a certificate of deposit for $40,000 that matures in April d Salaries are $145,000 per month . The monthly mortgage payment is 325,000 f Monthly depreciation is $20,000 Property tax of $35,000 is due in February

Answer & Explanation Solved by verified expert
Get Answers to Unlimited Questions

Join us to gain access to millions of questions and expert answers. Enjoy exclusive benefits tailored just for you!

Membership Benefits:
  • Unlimited Question Access with detailed Answers
  • Zin AI - 3 Million Words
  • 10 Dall-E 3 Images
  • 20 Plot Generations
  • Conversation with Dialogue Memory
  • No Ads, Ever!
  • Access to Our Best AI Platform: Flex AI - Your personal assistant for all your inquiries!
Become a Member

Other questions asked by students