Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

plz do J or K or even both this is what i have so far 4. The Right Target, Inc., a marketing research and consulting

plz do J or K or even both image text in transcribed
image text in transcribed
this is what i have so far
4. The Right Target, Inc., a marketing research and consulting firm, is working on a cash budget for July to December 2017. The staff has projected the following cash collections and payments: Collections Payments Cash Sales Credit Sales Purchases Wages Miscellaneous Expenses July $10,000 $20,000 $15,000 $6000 $1,500 August $12,000 $24,000 $18,000 $7,200 $2,000 Scotcmcr14.00000020400 2 7500 Octobs $16.000 $2,000 $24,000 $9,600 $3,000 November 20.000 10000 SOTOOSI 27000 $4,000 Decemb295.0005 _37 15000 4.500 1) If the ending cash balance as of June 30, 2017 was $10,000, determine the firm's forecasted monthly cash balance. 1) The staff at The Right Target, Inc. wants to know how much they would need to borrow each month if the minimum ending cash balance is $30,000 and the annual interest rate is 7%. k) Determine the impact on the ending cash balance if the firm uses any cash surplus above the required minimum cash balance to pay off its short-term borrowing monthly. 2 Collections Payments Cash Sales C edit Sales Purchases Wages Miscellaneous Expenses Net Collection Beginning Balance Ending Balance Ending Cash balance $10,000 $20,000 $15,000 56,000 $1,500 $10.000 $12.000 $24.000 $18.000 S7 200 $2.000 58.800 $10,000 $18.800 $14,000 $28,000 $21,000 $3,400 $2.500 $10.100 $10.000 $28.900 $16.000 $32.000 524.000 59.500 $3.000 $11.400 $28.900 540,300 520,000 540,000 $30,000 $12,000 $4,000 $14,000 540,300 $54,300 $25,000 $50 000 $37.500 $15.000 SE500 $18.000 554,300 $72,300

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

Step: 3

blur-text-image

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

College Accounting Ch 1-12

Authors: Dansby

5th Edition

0763834955, 978-0763834951

More Books

Students also viewed these Accounting questions

Question

16.3 Describe the purpose of Canadian labour laws.

Answered: 1 week ago

Question

16.6 Outline the three waysto obtain union recognition.

Answered: 1 week ago

Question

16.5 Describe the five steps in a union organizing campaign.

Answered: 1 week ago