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:
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...
-
The observer in FIGURE 26-65 is positioned so that the far edge of the bottom of the empty glass (not to scale) is just visible. When the glass is filled to the top with water, the center of the...
-
Darius Lowe gives you the following information as at 31 March 2024: His mark-up is 40% on cost of goods sold. His average inventory during the year was 14,000. Draw up an income statement for the...
-
The following information was obtained from recent annual reports on \(10-\mathrm{K}\) for American Eagle Outfitters, Inc. Compute the debt-to-equity ratio (a) including deferred tax liabilities as...
-
At the end of the fiscal year, Siglo Delivery Services trial balance appeared as follows. Required 1. Enter the trial balance amounts in the Trial Balance columns of a work sheet and complete the...
-
A manufactured product has the following information for August. Direct materials Direct labor Overhead Units manufactured Total manufacturing costs Standard Quantity and Cost 2 pounds per unit $3.00...
-
Embutidos Vallina SA has two direct-cost categories: direct materials and direct manufacturing labour. Its single indirect-cost category (manufacturing overhead) is allocated on the basis of...
-
Compute the missing amounts (in millions) in the following table. (The balance in retained earnings at year-end 2012 was $2.2.) comment on the firm's performance over the three-year period after...
-
Rings Company has three product lines, A, B, and C. The following financial information is available: Item Sales Product Line A Product Line B Product Line C $ 42,000 $ 75,000 $ 18,000 Variable costs...
-
Determine the support forces acting on the beam (10 ft) at points A and D. pinned 1000 lb 45 3 ft B 2 ft C 400 lb/ft 5 ft D roller
-
HOW THIS POINTS CAN BE REALATED TO A CLICK THROUGH RATE AN EMAIL AS A MARKETING CAMPAING FOR A HOTEL?
-
Mary and Chuck, unmarried individuals, are both 29 years of age. For 2023, Mary and Chuck will earn wages of $60,000 and $35,000, respectively. This will be their only source of income. They are...
-
How does bounded rationality affect the way an entrepreneur determine what business to start?
-
ABC Co. is considering a project that has the following cash flow data. What is the project's IRR? Note that a project's projected IRR can be less than the WACC (and even negative), in which case it...
-
B made an issue of 150,000 $1 ordinary shares at a premium of 20% the proceeds of which is received by cheque. What is the correct journal to record this? A. Bank Share capital Share premium B. Bank...
-
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....
-
Which of the following is not a way to develop a standard cost? a. By using a fixed rate that is higher every period. b. By performing time and motion studies. c. By analyzing past data. d. By using...
-
The total material variance can be divided into a material _________variance and a material _________variance.
-
Which of the following statements correctly de scribes an unfavorable material price variance? a. Too much material was purchased. b. A higher price was paid for material purchased compared with the...
Study smarter with the SolutionInn App