Create a cash forecasting schedule ( good for 3 months ) Choose your company and industry. You
Fantastic news! We've Found the answer you've been seeking!
Question:
- Create a cash forecasting schedule (good for 3 months) Choose your company and industry. You may wish to pattern this to an already existing company or create a new one (it can be your own dream company).
- Please use excel spreadsheets and indicate the name of the company.
- Other conditions:
- Depending on the size of the company, you can start with PhP250,000 up to PhP500,000 in the first month of sales/cash inflow. Be sure to have an increase of 25% per month.
- Consider all necessary expenses related to your company.
- Please also provide a brief description (1 paragraph) of the company in a separate tab.
Example Template:
Transcribed Image Text:
1. Operating Cash- Beginning 2. Sources of New Cash Cash Sales AR Collections Customer Deposits Bank Financing Shareholder Investment Other 3. Total Sources of Cash 4. Uses of Cash Payroll Rent Utilties Taxes Inventory Purchases Loan Payments Other 5. Total Uses of Cash 6. Cash Row (Deficit) January $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ February March April May 50,000 $35,300 $26,600 $17,900 $ 5,000 $6,000 $6,000 $4,000 $ $5,000 $6,000 $6,000 $ 2,000 $2,000 $1,000 $1,000 $ $ $ 57,000 $ $ S $48,300 . June July August September December 7,200 $2,500 $20,800 $23,700 $ 18,600 $ 16,500 $ $ $ $ S . $ $39,600 $28,900 $ 19,200 . 4,000 $4,000 $5,000 $7,000 $ 7,000 $7,000 $5,000 $6,000 $ 1.000 $2,000 $3,000 $3,000 $ $20,000 $ . $ $ $10,000 $10,000 $ $- $ $ $40,500 $43,800 $ 8,000 $ 8,000 $ 4,000 $ $ $ 9,000 8,000 7,000 $ $ $39,700 $ 38,600 $ 40,500 10,000 $10,000 $10,000 $10,000 $10,000 $10,000 $10,000 $10,000 $10,000 $10,000 3,500 $3,500 $3,500 $3,500 $ 3,500 $3,500 $3,500 $3,500 $ 3,500 $ 1,500 $1,500 $ 1.500 $1,500 $ 1.500 $1,500 $1,500 $1,500 $ 1,200 $1,200 $1,200 $1,200 $ 1,200 $1,200 $1,200 $ 1,200 $ 5,000 $5,000 $5,000 $5,000 $ 5,000 $3,000 $3,000 $4,000 $ $ $ $ $ $ $ 400 $ 400 $ 500 $ 500 $ 500 $ 500 $ 500 $500 $500 $500 $ 21,700 $21,700 $21,700 $21,700 $ 21,700 $19,700 $20,100 $21,100 $ 35,300 $26,600 $17,900 $ 7,200 $2,500.00 $20,800 $23,700 $18,600 $ 1,500 $ 1,200 $ 5,000 $ - 400 $ 500 $ 3,500 1.500 1,200 6,000 400 500 22,100 $ 23,100 16,500 $17,400 1. Operating Cash- Beginning 2. Sources of New Cash Cash Sales AR Collections Customer Deposits Bank Financing Shareholder Investment Other 3. Total Sources of Cash 4. Uses of Cash Payroll Rent Utilties Taxes Inventory Purchases Loan Payments Other 5. Total Uses of Cash 6. Cash Row (Deficit) January $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ February March April May 50,000 $35,300 $26,600 $17,900 $ 5,000 $6,000 $6,000 $4,000 $ $5,000 $6,000 $6,000 $ 2,000 $2,000 $1,000 $1,000 $ $ $ 57,000 $ $ S $48,300 . June July August September December 7,200 $2,500 $20,800 $23,700 $ 18,600 $ 16,500 $ $ $ $ S . $ $39,600 $28,900 $ 19,200 . 4,000 $4,000 $5,000 $7,000 $ 7,000 $7,000 $5,000 $6,000 $ 1.000 $2,000 $3,000 $3,000 $ $20,000 $ . $ $ $10,000 $10,000 $ $- $ $ $40,500 $43,800 $ 8,000 $ 8,000 $ 4,000 $ $ $ 9,000 8,000 7,000 $ $ $39,700 $ 38,600 $ 40,500 10,000 $10,000 $10,000 $10,000 $10,000 $10,000 $10,000 $10,000 $10,000 $10,000 3,500 $3,500 $3,500 $3,500 $ 3,500 $3,500 $3,500 $3,500 $ 3,500 $ 1,500 $1,500 $ 1.500 $1,500 $ 1.500 $1,500 $1,500 $1,500 $ 1,200 $1,200 $1,200 $1,200 $ 1,200 $1,200 $1,200 $ 1,200 $ 5,000 $5,000 $5,000 $5,000 $ 5,000 $3,000 $3,000 $4,000 $ $ $ $ $ $ $ 400 $ 400 $ 500 $ 500 $ 500 $ 500 $ 500 $500 $500 $500 $ 21,700 $21,700 $21,700 $21,700 $ 21,700 $19,700 $20,100 $21,100 $ 35,300 $26,600 $17,900 $ 7,200 $2,500.00 $20,800 $23,700 $18,600 $ 1,500 $ 1,200 $ 5,000 $ - 400 $ 500 $ 3,500 1.500 1,200 6,000 400 500 22,100 $ 23,100 16,500 $17,400
Expert Answer:
Answer rating: 100% (QA)
Chic Chic Ltd is a company in meat industry that deals with slaughtering and selling deboned chicken Below is a schedule of a forecasted cash flow for ... View the full answer
Posted Date:
Students also viewed these accounting questions
-
Please research two companies, one an example of company with an effective strategic plan the other with an ineffective strategy. Provide the following analysis for each company: A detailed...
-
Provide an example where you have compared a good or service by its value and compared perceived benefits and price. How did your assessment of value led to a purchase (or non-purchase) decision?
-
One can uncover the pattern size with the following code. The code accesses the raw device to avoid file system optimizations. The key to all of the Shear algorithms is to use random requests to...
-
IKEA was founded in 1943 by a 17-year-old Swede named Ingvar Kamprad. The company, which initially sold pens, Christmas cards, and seeds from a shed on Kamprad?s family farm, eventually grew into a...
-
Why are the four primary service outputs of spatial convenience, lot size, waiting time, and product variety important to logistics management? Provide examples of competing firms that differ in the...
-
A candidate for mayor in a small town has allocated $40,000 for last-minute advertising in the days preceding the election. Two types of ads will be used: radio and television. Each radio ad costs...
-
How does multiplicity relate to business rules? Give an example.
-
A large number of firms are capable of producing chocolate- covered cockroaches. The linear, upward-sloping supply curve starts on the price axis at $ 6 per box. A few hardy consumers are willing to...
-
Use the following information to determine the net income or loss of a plumber, operating as a sole trader. Cash A/C 22,000 Plumbing supplies A/C 5,000 Plumbing service revenue A/C 40,000 Wages...
-
Apu, Barney, Clancy, Homer, and Seymour (none of whom are related to one another), working together, form the Be Sharps Corporation ("Sharps") on January 1, 20x1. The corporation only issues voting,...
-
A structure of two welded plates is fixed at point A by a ball joint, at point B by a cylindrical hinge, and at points by a supporting rod. Two forces (according to Loading Diagram number) and a...
-
What red flag was overlooked on the Montague Fellowship Expense Report?
-
Gatekeeper Manufacturing reported 50,000 physical units that were 100% complete for direct materials during the period. In addition, the 50,000 physical units were 100% for conversion costs. In terms...
-
The blue samurai, a japanese restraurant, has an asset turnover of 3.5 the total assets were 95,000 what are net sales for the blue samurai?
-
What amount of gain should Pharoah recognize on the exchange assuming lack of commercial substance?
-
4. The water in Earth's atmosphere blocks most of the infrared waves coming from space. In order to observe light of this wavelength, the Kuiper Airborne Observatory has been developed. The...
-
I am having problems running my program. When I run the below code I get "File cannot be opened: Could not load, no such directory". public class Media { // Attributes int id; String title; int year;...
-
Create an appropriate display of the navel data collected in Exercise 25 of Section 3.1. Discuss any special properties of this distribution. Exercise 25 The navel ratio is defined to be a persons...
-
Catherine Rampell is an economics writer for the Washington Post. In an article in 2023, she observes that the average U.S. tariff rate on mens underwear is 11.5 percent. The average rate on womens...
-
An opinion column in the Wall Street Journal argued that Americans enjoy comparative advantages in [service] sectors such as construction and engineering, but global trade in services is weighed down...
-
An article in the Wall Street Journal explained that despite rising national security tensions between the United States and China in 2023, trade between the two nations was rising. China is a...
Study smarter with the SolutionInn App