Below is the sales forecast, in dollars, for the upcoming year for Houseware Store. Houseware store...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
Below is the sales forecast, in dollars, for the upcoming year for Houseware Store. Houseware store collects 15% of each month's sales in cash, 49% one month later, and 32% the second month after the sale. 4% of sales are bad debt. A given month's purchases are 60% of the forecasted sales amount for that month and 15% of the previous months sales forecast ( 14 of materials are bought for cash, the other % are paid on "net 30 terms"). The other cash flows for JUNE through AUGUST are $35 interest income to be received in JUNE, a principal repayment of $30 in JULY, interest payment of $50 in JUNE, tax payments of $80 in AUGUST, cash proceeds from asset sale of $65 in AUGUST, and payment for asset acquisitions of $45 in JULY. The company's policy mandates that a minimum of $150 be kept in cash at all times. Ending cash in MAY is projected to be $215, and the company has no outstanding short-term borrowing or investments at that time. Month Sales Forecast January $45 Feb. 48 Mar. Apr. May Jun. July Aug. 50 52 63 59 76 83 Based on this information, prepare cash forecast for JUNE through AUGUST using the cash receipts and disbursements method. (Keep 2 decimal digits) Interpret your forecast. State the maximum funds available to be invested over this period, and the maximum funds needed to be borrowed. Below is the sales forecast, in dollars, for the upcoming year for Houseware Store. Houseware store collects 15% of each month's sales in cash, 49% one month later, and 32% the second month after the sale. 4% of sales are bad debt. A given month's purchases are 60% of the forecasted sales amount for that month and 15% of the previous months sales forecast ( 14 of materials are bought for cash, the other % are paid on "net 30 terms"). The other cash flows for JUNE through AUGUST are $35 interest income to be received in JUNE, a principal repayment of $30 in JULY, interest payment of $50 in JUNE, tax payments of $80 in AUGUST, cash proceeds from asset sale of $65 in AUGUST, and payment for asset acquisitions of $45 in JULY. The company's policy mandates that a minimum of $150 be kept in cash at all times. Ending cash in MAY is projected to be $215, and the company has no outstanding short-term borrowing or investments at that time. Month Sales Forecast January $45 Feb. 48 Mar. Apr. May Jun. July Aug. 50 52 63 59 76 83 Based on this information, prepare cash forecast for JUNE through AUGUST using the cash receipts and disbursements method. (Keep 2 decimal digits) Interpret your forecast. State the maximum funds available to be invested over this period, and the maximum funds needed to be borrowed.
Expert Answer:
Answer rating: 100% (QA)
To prepare the cash forecast for June through August using the cash receipts and disbursements method we need to calculate the cash receipts and cash ... View the full answer
Related Book For
Income Tax Fundamentals 2013
ISBN: 9781285586618
31st Edition
Authors: Gerald E. Whittenburg, Martha Altus Buller, Steven L Gill
Posted Date:
Students also viewed these finance questions
-
Managing Scope Changes Case Study Scope changes on a project can occur regardless of how well the project is planned or executed. Scope changes can be the result of something that was omitted during...
-
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...
-
The Crazy Eddie fraud may appear smaller and gentler than the massive billion-dollar frauds exposed in recent times, such as Bernie Madoffs Ponzi scheme, frauds in the subprime mortgage market, the...
-
Graph the exponential equation. Then state the inverse function in logarithmic form and graph it. Then state the domain and range of each function. = ()* = to Domain: Range: Inverse: Domain: Range:...
-
The quarter ring shown has a mass m and was cut from a thin, uniform plate. Knowing that r 1 = r 2 , determine the mass moment of inertia of the quarter ring with respect to (a) Axis AA, (b) The...
-
How do you select trade study decision factors, criteria, and weights?
-
Olympic Village Enterprises lost its entire inventory in a hurricane that occurred on July 31,2010. Over the past five years, gross profit has averaged 30% of net sales. The companys records reveal...
-
Here are some historical data on the risk characteristics of Dell and Microsoft: Assume the standard deviation of the return on the market was 15 percent. a. The correlation coefficient of Dell?s...
-
Congratulations! You've just been hired by Acme Enterprises as a compensation analyst. For your first project, your boss wants a compensation analysis of Acme's office staff which has experienced...
-
The Classic Furniture Company is trying to determine the optimal quantities to make of six possible products: tables and chairs made of oak, cherry, and pine. The products are to be made using the...
-
View carefully the YouTube video entitled "VIP Speaker Series: Pepsi CEO Indra Nooyi Speaks at McCombs." This was a videotaped interview with Indra Nooyi, Chairman and Chief Executive Officer of...
-
3. Assume job1 and job2 with the following characteristics are active in a system with 200M of memory: (job1 has higher priority) multiprogramming Jobl job2 Duration CPU needed Memory needed Disk...
-
work 3 ework 3 ork 3 K K As a result of winning the Gates Energy Innovation Award, you are awarded a growing perpetuity. The first payment will occur in a year and will be for $10,000. You will...
-
One of the biggest impacts of ___________ is the requirement for companies and their auditors to provide reports about the effectiveness of internal controls over the financial reporting process....
-
Consider the function f(x) := 1 x. If the function is one-to-one, give its inverse in the box below, writing the inverse in the format "y=m*x+b" without quotation marks and replacing m and b by their...
-
Perform the forward and backward path analysis for the following diagram. Calculate the value of the total float and free float. (a) Identify the critical path. (b) If activity E were to have a 5-day...
-
A T-bill is a type of bond that is sold at a discount over the face value. For example, suppose you buy a 13-week T-bill with a face value of $10,000 for $9,800. This means that in 13 weeks, the...
-
a. Why does the Wi-Fi Alliance release compatibility testing profiles in waves instead of combining the entire standards features initially? 27a1.) An 802.11ac Wi-Fi compatibility testing profile...
-
Matthew borrows $250,000 to invest in bonds. During 2012, his interest on the loan is $30,000. Matthew's interest income from the bonds is $10,000. This is Matthew's only investment income. a....
-
Sherry rents her vacation home for 6 months and lives in it for 6 months during the year. Her gross rental income during the year is $4,000. Total real estate taxes for the home are $950, and...
-
In 2012, Margaret and John Murphy are married taxpayers who file a joint tax return with AGl of $25,000. During the year they incurred the following expenses: Hospitalization insurance...
-
What is the relative frequency of direct hits that were AT MOST a category 3 storm? a. 0.3480 b. 0.9231 c. 0.2601 d. 0.3370 Table 1.18 contains data on hurricanes that have made direct hits on the...
-
A survey of 250 members from an organized union of over 20,000 members. In Exercises 1120, determine whether the data set is a population or a sample. Explain your reasoning.
-
The carbon monoxide levels of 12 of 49 people who escaped a burning building. In Exercises 1120, determine whether the data set is a population or a sample. Explain your reasoning.
Study smarter with the SolutionInn App