The Right Target, Inc., a marketing research and consulting firm, is working on a cash budget...
Fantastic news! We've Found the answer you've been seeking!
Question:
![The Right Target, Inc., a marketing research and consulting firm, is working on a cash budget for July to](https://dsd5zvtm8ll6.cloudfront.net/si.experts.images/questions/2023/09/651521897b45c_1695927000939.jpg)
Transcribed Image Text:
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 Month Cash Sales $10,000 $12,000 $14,000 $16,000 $20,000 Credit Sales Purchases Wages Miscellaneous Expenses $6000 $1,500 $2,000 $2,500 $3,000 $4,000 $4,500 July $20,000 $24,000 $28,000 August September October November $32,000 $40,000 December $25,000 $50,000 a) If the ending cash balance as of June 30, 2017 was $10,000, determine the firm's forecasted monthly cash balance. $15,000 $18,000 $7.200 $21,000 $8,400 $24,000 $9,600 $30,000 $12,000 $37,500 $15,000 b) 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%. c) 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. 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 Month Cash Sales $10,000 $12,000 $14,000 $16,000 $20,000 Credit Sales Purchases Wages Miscellaneous Expenses $6000 $1,500 $2,000 $2,500 $3,000 $4,000 $4,500 July $20,000 $24,000 $28,000 August September October November $32,000 $40,000 December $25,000 $50,000 a) If the ending cash balance as of June 30, 2017 was $10,000, determine the firm's forecasted monthly cash balance. $15,000 $18,000 $7.200 $21,000 $8,400 $24,000 $9,600 $30,000 $12,000 $37,500 $15,000 b) 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%. c) 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.
Expert Answer:
Answer rating: 100% (QA)
a To determine the firms forecasted monthly cash balance well start with the ending cash balance as of June 30 2017 which is 10000 and then add or sub... View the full answer
Related Book For
Financial Management Theory and Practice
ISBN: 978-1305632295
15th edition
Authors: Eugene F. Brigham, Michael C. Ehrhardt
Posted Date:
Students also viewed these finance questions
-
In a conversation about water contamination in Flint, Michigan in an online forum, two individuals are making claims you are sceptical of and refuse to provide evidence to support their claims. They...
-
The following additional information is available for the Dr. Ivan and Irene Incisor family from Chapters 1-5. Ivan's grandfather died and left a portfolio of municipal bonds. In 2012, they pay Ivan...
-
A partially completed worksheet for Scott Wilson, CPA, for the month ending June 30, 2013, is shown below. INSTRUCTIONS 1. Record the balances as of June 30 in the ledger accounts. 2. Prepare the...
-
A module can be considered a(n) object or unit that can be combined or bound together to form a application. a. Dependent, big and complex b. Dependent, small and easier c. Independent, big and...
-
1. Record the above activity, and then prepare an income statement for July 2009 and a balance sheet as of July 31, 2010. 2. Was DSAC successful during its first month of operation? Explain. Rachel...
-
What are tax repairs asked to do to prevent filing returns with stolen identities?
-
Should Tana, a young entrepreneur who is launching a new line of environmentally friendly (green) cosmetics, sell through a physical store, catalog, or Internet? Explain two key benefits of each...
-
Prepare a tax return for Charlie and Cindy Clergy. Charlie Clergy (age 44, DOB: 5/2/76, SSN: 453-00-9863), whose Form W-2s and 1099s follow, is an ordained minister in the Episcopal Church. His wife,...
-
Beauty Beyond Words Salonuses an actity-based conting system to determine the cost of services. The salon has determined the cols of services by activity and activity usage as follows Activity...
-
In the first phase of the project: 1. Identify team members (Maximum five are allowed) 2. Create your account on kaggle.com 3. Explore various datasets available over kaggle.com 4. Select a problem...
-
The following additional information is relevant: 1. TrustHavens revenues include RM7 million of goods it sold acting as an agent for UpCT for which it earned a commission of 20% on these sales and...
-
The table below shows the population of Mozambique between 1960 and 2010. This data can be modelled using an exponential function of the form P = ab t , where t is the time in years since 1960 and a...
-
Southco is a medium-sized American-owned global manufacturer of access hardware solutions, such as latches and hinges, used for applications in the aircraft, railway, computer and automotive...
-
To what extent do staffing processes at the Dionysos reflect the strategic approach to recruitment and selection encapsulated by the conceptual framework and model depicted in Key Concepts 8.4 and...
-
Im an accounting major, not an operations expert, yelled just-promoted Bob Barthrow, the executive vice president of the Midwest Frequent Flyer Call Center, during a senior-level management meeting....
-
The Hudson Jewelers case study can be found in Appendix C. Chapter 14 Case Question for Discussion: 1.Customer demand (weekly visits) at Hudson Jewelers is highly seasonal, as shown in the worksheet...
-
3. Intrinsic values and stock prices The intrinsic value of a company's stock, also known as its fundamental value, refers to the stock's "true" value based on accurate risk and return data. The...
-
Read the Forecasting Supply Chain Demand Starbucks Corporation case in your text Operations and Supply Chain Management on pages 484-485, then address the four questions associated with the...
-
a. Using the free cash flow valuation model, show the only avenues by which capital structure can affect value. b. (1) What is business risk? What factors influence a firm's business risk? (2) What...
-
Garlington Technologies Inc.'s 2016 financial statements are shown below: Balance Sheet as of December 31, 2016 Cash ................................. $ 180,000 ........... Accounts payable...
-
Define each of the following terms: a. Proxy; proxy fight; preemptive right; classified stock; founders' shares b. Free cash flow valuation model, value of operations; non-operating assets c....
-
16. The Willingham Museum qualifies as a component unit of the City of Willingham. How does an activity or function qualify to be a component unit of a primary government?
-
13. What does the managements discussion and analysis (MD&A) normally include? Where does a state or local government present this information?
-
12. What impact does the use of the modified approach have on reporting within the government-wide financial statements?
![Mobile App Logo](https://dsd5zvtm8ll6.cloudfront.net/includes/images/mobile/finalLogo.png)
Study smarter with the SolutionInn App