Prepare a Business Memo on Cash Forecasting that answers the following questions: When will the company run
Question:
Prepare a Business Memo on Cash Forecasting that answers the following questions:
When will the company run out of cash?
What solutions do you have for the company to help them have enough cash for operations?
How much additional cash will the company need to generate in order to have enough to operate until year end?
If the Monthly Growth rate goes from 1% versus the prior month (current assumption for all stores) to negative 5% how long until the company runs out of cash?
How much additional cash will the company need access to in order to have enough to operate until year end?
Using this summary table:
1% Growth Sales All Costs Total Cashflows G&A EBITDA Begging Cash Principle Payment CAPEx expense Change in WC Ending Cash 5% Growth Sales All Costs Total Cashflows G&A EBITDA Begging Cash Principle Payment CAPex expense Change in WC Ending Cash ▶ 5.096 5.0% Period 1 $50,000.00 $ 20,000.00 $ 28,000.00 2.0% $ 632,000 586,423 45,577 31,600 $ 13977.00 Period 1 $ Period 2 $ 50,000.00 $ 50,000.00 $ 35,977 $ 24,743 $ $ 20,000.00 $ 28,000.00 $ 2.0% 632,000 586,423 45,577 31,600 $ 50,000.00 638,320 589,512 48,808 31,916 $ 16891.90 13,977 $ Period 2 $ 20,000.00 (28,000.00) $ (28,000.00) $ (28,000.00) $ (28,000.00) $ $ (126.40) $ (3,351.18) $ 3,094.58 $ $ 35,977.00 $ 24,742.50 $ 12,686.26 $ 8,715.95 $ Period 3 600,400 562,996 37,404 30,020 43361.21 805,879 726,290 79,589 40,294 $ 39294.94 7,384 $ Period 4 Period 3 712,975 669,059 43,916 35,649 Period 5 651,150 597,658 53,493 32,558 $ 20935.12 8,267 $ 12,686 $ Period 4 541,861 528,470 13,391 27,093 (13,702) $ 657,662 600,837 56,825 32,883 $ 23941.88 Period 5 Period 6 8,716 S S (28,000.00) $ (130.23) S 4,527.60 $ 514,768 507,027 7,741 25,738 (17,997) $ (82,269) $ 35,977.00 Assignment Summary TotalAllStore RestaurantBudget In Store1 (39,693) 24260.52 $ 20,000.00 $ $ (28,000.00) $ (28,000.00) $ (28,000.00) $ (28,000.00) $ (28,000.00) $ 632 542 15993.21 (2,252) -25990.98 3,422 -64271.2 -109726.73 Period 6 830,298 742,579 87,719 41,515 $ 46203.72 Period 7 4,528 $ 20,000.00 (28,000.00) $ (3,452.72) $ (721.40) $ 611,287 602,380 8,907 30,564 (21,657) $ Period 8 670,881 609,102 61,778 33,544 $ 28234.30 Period 7 (721) $ 2,701 S $ (28,000.00) $ (28,000.00) $ 3,188.34 $ (134.18) $ 2,701.24 $ 3,897.87 $ 677,590 614,379 63,210 33,879 $ 29330.81 Period 8 464,578 474,193 (9,615) 23,229 (32,844) $ (214,159) Period 9 (280,755) 441,349 460,812 (19,463) 22,067 (41,530) $ Store ... (131,384) 20,000.00 Ś (28,000.00) $ (28,000.00) $ (28,000.00) $ (1,930) 465 -181314.75 -308290.32 2,934 -239224.66 Store2 Store3 + Period 9 855,457 759,733 95,723 42,773 $ 52950.50 Period 10 524,102 545,090 (20,988) 26,205 (47,193) $ 4 Period 11 691,209 623,118 68,091 34,560 $ 33530.41 Period 10 14,106 S 3,898 $ 20,797 20,000.00 $ 20,000.00 (28,000.00) $ (28,000.00) $ (28,000.00) $ (28,000.00) (3,557.35) $ 3,284.95 $ (138.24) $ (3,665.14) 5,291.03 $ 14,106.39 $ 20,797.30 $ 60,526.34 5,291 $ Period 12 698,121 628,386 69,735 34,906 $ 34829.15 Period 11 398,318 435,597 (37,279) 19,916 (57,195) $ (462,333) 881,378 776,783 104,595 44,069 60526.34 Period 12 378,402 421,970 (43,568) 18,920 (62,488) $ (550,305) Total 8,689,944 7,854,801 835,143 434,497 400646.00 Total 449,352 6,269,392 503,617 6,297,634 (54,265) 22,468 (76,733) $ (28,242) 313,469 (341,711) (355,483) (654,640) (1,045,771) 20,000.00 $ 20,000.00 (28,000.00) $ (28,000.00) $ (28,000.00) $ (28,000.00) (1,655) 2,516 398 (1,419) -405138.1 -487817.35 -577907.08 -704059.07 (28,000) (116,401) 1190171.9 % of Sale 90% 10% 5% 596 596 1% Growth Sales All Costs Total Cashflows G&A EBITDA Begging Cash Principle Payment CAPEx expense Change in WC Ending Cash 5% Growth Sales All Costs Total Cashflows G&A EBITDA Begging Cash Principle Payment CAPex expense Change in WC Ending Cash ▶ 5.096 5.0% Period 1 $50,000.00 $ 20,000.00 $ 28,000.00 2.0% $ 632,000 586,423 45,577 31,600 $ 13977.00 Period 1 $ Period 2 $ 50,000.00 $ 50,000.00 $ 35,977 $ 24,743 $ $ 20,000.00 $ 28,000.00 $ 2.0% 632,000 586,423 45,577 31,600 $ 50,000.00 638,320 589,512 48,808 31,916 $ 16891.90 13,977 $ Period 2 $ 20,000.00 (28,000.00) $ (28,000.00) $ (28,000.00) $ (28,000.00) $ $ (126.40) $ (3,351.18) $ 3,094.58 $ $ 35,977.00 $ 24,742.50 $ 12,686.26 $ 8,715.95 $ Period 3 600,400 562,996 37,404 30,020 43361.21 805,879 726,290 79,589 40,294 $ 39294.94 7,384 $ Period 4 Period 3 712,975 669,059 43,916 35,649 Period 5 651,150 597,658 53,493 32,558 $ 20935.12 8,267 $ 12,686 $ Period 4 541,861 528,470 13,391 27,093 (13,702) $ 657,662 600,837 56,825 32,883 $ 23941.88 Period 5 Period 6 8,716 S S (28,000.00) $ (130.23) S 4,527.60 $ 514,768 507,027 7,741 25,738 (17,997) $ (82,269) $ 35,977.00 Assignment Summary TotalAllStore RestaurantBudget In Store1 (39,693) 24260.52 $ 20,000.00 $ $ (28,000.00) $ (28,000.00) $ (28,000.00) $ (28,000.00) $ (28,000.00) $ 632 542 15993.21 (2,252) -25990.98 3,422 -64271.2 -109726.73 Period 6 830,298 742,579 87,719 41,515 $ 46203.72 Period 7 4,528 $ 20,000.00 (28,000.00) $ (3,452.72) $ (721.40) $ 611,287 602,380 8,907 30,564 (21,657) $ Period 8 670,881 609,102 61,778 33,544 $ 28234.30 Period 7 (721) $ 2,701 S $ (28,000.00) $ (28,000.00) $ 3,188.34 $ (134.18) $ 2,701.24 $ 3,897.87 $ 677,590 614,379 63,210 33,879 $ 29330.81 Period 8 464,578 474,193 (9,615) 23,229 (32,844) $ (214,159) Period 9 (280,755) 441,349 460,812 (19,463) 22,067 (41,530) $ Store ... (131,384) 20,000.00 Ś (28,000.00) $ (28,000.00) $ (28,000.00) $ (1,930) 465 -181314.75 -308290.32 2,934 -239224.66 Store2 Store3 + Period 9 855,457 759,733 95,723 42,773 $ 52950.50 Period 10 524,102 545,090 (20,988) 26,205 (47,193) $ 4 Period 11 691,209 623,118 68,091 34,560 $ 33530.41 Period 10 14,106 S 3,898 $ 20,797 20,000.00 $ 20,000.00 (28,000.00) $ (28,000.00) $ (28,000.00) $ (28,000.00) (3,557.35) $ 3,284.95 $ (138.24) $ (3,665.14) 5,291.03 $ 14,106.39 $ 20,797.30 $ 60,526.34 5,291 $ Period 12 698,121 628,386 69,735 34,906 $ 34829.15 Period 11 398,318 435,597 (37,279) 19,916 (57,195) $ (462,333) 881,378 776,783 104,595 44,069 60526.34 Period 12 378,402 421,970 (43,568) 18,920 (62,488) $ (550,305) Total 8,689,944 7,854,801 835,143 434,497 400646.00 Total 449,352 6,269,392 503,617 6,297,634 (54,265) 22,468 (76,733) $ (28,242) 313,469 (341,711) (355,483) (654,640) (1,045,771) 20,000.00 $ 20,000.00 (28,000.00) $ (28,000.00) $ (28,000.00) $ (28,000.00) (1,655) 2,516 398 (1,419) -405138.1 -487817.35 -577907.08 -704059.07 (28,000) (116,401) 1190171.9 % of Sale 90% 10% 5% 596 596
Expert Answer:
Intermediate Accounting Volume 1
ISBN: 9781260306743
7th Edition
Authors: Thomas H. Beechy, Joan E. Conrod, Elizabeth Farrell, Ingrid McLeod Dick
Students also viewed these finance questions
-
Planning is one of the most important management functions in any business. A front office managers first step in planning should involve determine the departments goals. Planning also includes...
-
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 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...
-
Jen and Barry's Ice Milk Company used cash to purchase a new ice milk mixer on January 1, 2013. The new mixer is estimated to have a 20,000 - hour service life. Jen and Barry's depreciates equipment...
-
Investors require a 15 percent rate of return on Levine Companys stock (rs =15%). a. What will be Levines stock value if the previous dividend was D0 = $2 and if investors expect dividends to grow at...
-
Starting with Eq. 5.51, derive expressions for the following response characteristics of the underdamped second-order system.(a) The time to first peak t (Eq. 5-52).(b) The fraction overshoot (Eq....
-
Use the data in Exercise 24 in Section 13.1 for the following. a. Compute a point estimate for the mean auditory response time for subjects with a visual response time of 200. b. Construct a 99%...
-
Determine the interest on the following notes. (Round to the nearest cent.) a. $58,940 at 6 percent for 60 days. b. $14,280 at 9 percent for 30 days. c. $30,600 at 12 percent for 60 days. d. $21,070...
-
Hi Tech Products manufactures three (3) types of CD players: Cheap, Econo and Deluxe. Hi Tech uses an activity-based product costing system. The company has identified five (5) activities. Each...
-
The following items were derived from Woodbine Circle Corporations adjusted trial balance on December 31, 2016: Other financial data for the year ended December 31, 2016: Federal Income Taxes Paid...
-
Discuss the reasons with appropriate examples why a shipowner may choose to appoint a third-party ship management company (3PL?
-
The British Broadcasting Corporation (BBC) recently announced the cancellation of a major Information Technology(IT) project intended to update their vast broadcast operations. The project, called...
-
Using your favorite search engine (Google, Yahoo!, etc.), type in the keywords project and project management. Randomly select three of the links that come up on the screen. Summarize what you find.
-
Evaluate the difference between direct and indirect costs when considering a project budget. What other common project costs can you identify?
-
Describe some of the benefits of developing budget contingencies for projects. Is it advantageous for project managers to apply contingency to every project? Justify your answer.
-
What are the main benefits of constructing a network diagram for a project? Why is it a useful project management tool?
-
The following information was obtained from matched samples. The daily production rates for a random sample of workers before and after a training program are shown below. Worker 1 2 3 4 5 6 7 Before...
-
Describe a job you have had in the past or a job you are very familiar with. Indicate the negative aspects of the job and how it could be improved with current human resource management techniques.
-
Grand Ltd. is a Canadian company that had the following transactions in 20X7: a. Sold goods to a customer in Belgium on 25 November for 220,000 euros. b. Sold goods to a U.S. customer on 25 November...
-
The records of Koop Co. provided the following information for the year ended 31 December 20X8: Additional information: a. Sold equipment for cash (cost, $30,000; accumulated depreciation, $18,000)....
-
Quispamsis Inc. (QI) recorded the following asset disposals during the year: a. A computer system with an original cost of $47,600, 80% depreciated, was judged obsolete during the period and...
-
Using data from a random sample of elementary schools, a researcher regresses average test scores on the fraction of students who qualify for reduced-price meals. The regression indicates a negative...
-
In the demand curve model of Equation (12.3), is \(\ln \left(P_{i}^{\text {butter }} ight)\) positively or negatively correlated with the error, \(u_{i}\) ? If \(\beta_{1}\) is estimated by OLS,...
-
In the study of cigarette demand in this chapter, suppose we used as an instrument the number of trees per capita in the state. Is this instrument relevant? Is it exogenous? Is it a valid instrument?
Study smarter with the SolutionInn App