Answered step by step
Verified Expert Solution
Question
1 Approved Answer
can you create a statement of cash flows from this? you csn make something up if need be 15 ng so 19000 B $27,000 D
can you create a statement of cash flows from this? you csn make something up if need be
15 ng so 19000 B $27,000 D E F G Notes on Preparation Note: Average retail building space is about $16-S20 per sqaure fe of buying a building we will rent one out. No construction cost sinc is already there. Wont be a lot of supplies in stock, becuase technicians will be brir equipment to customers home when they install. I based the numbers off how much it cost to own a franchise AT8 the buyer anywhere from 200-250 thousand. $ 27,000 3 4 Buildings/Real Estate 5 Purchase 6 Construction 7 Remodeling 8 Other 9 Total Buildings/Real Estate 0 1 Capital Equipment List 2 Furniture 3 Equipment 4 Fixtures 5 Machinery Other 7 Total Capital Equipment 3 Location and Admin Expenses Rent & Related Costs Utility deposits Legal and accounting fees Prepaid insurance Beginning Expenses sources of Capital Cash low $15,000 $10,000 $4,000 $ 29,000 $2,333 $2,000 $1,000 $3,600 Prohit-Loss Analysis B52 19000 $45,000 $ 53,933 $15,000 Cable boxes Modems remote controllers 24 Pre-opening or pre-implementing salaries 25 Other 26 Total Location and Admin Expenses 27 28 Opening Inventory / Supplies Needed 29 Category 1 50 Category 2 -1 Category 3 2 Category 4 3 Category 5 4 Total Inventory 5 Advertising and Promotional Expenses Advertising Signage Printing Travel/entertainment Other/additional categories Total Advertising/Promotional Expenses $ 15,000 $60,000 $1,000 $15,000 $3,000 $4,000 83,000 $ Other Expenses Beginning Expenses Sources of Capital Cash Flow Profit-Loss Analysis fi 19000 $ 83,000 $10,000 A Total Advertising/Promotional Expenses 3 Other Expenses Other expense 1 = Other expense 2 Other expense 3 Other expense 4 Other expense 5 Total Other Expenses $ 10,000 Reserve for Contingencies $19,000 Summary Statement of Beginning Expenses $ Beginning Expenses Buildings/real estate Capital equipment Location/administration expenses Anoninainuantan Beginning Expenses Sources of Capital Cash Flow 27,000 29,000 53,933 16 non Profit -Loss Analysis Type here to search at e D B $19,000 Reserve for Contingencies Summary Statement of Beginning Expenses $ Beginning Expenses Buildings/real estate Capital equipment Location/administration expenses Opening inventory Advertising/promotional expenses Other expenses Contingency fund Total Startup Expenses 27,000 29,000 53,933 15,000 83,000 10,000 19,000 236,933 $ Beginning Expenses Sources of Capital Cash Flow Profit-Loss Analysis Type here to search ORP e B D E 8 Total Investment $ 240,000 would think he would have good i 9 10 Bank Loans Needed 11 Bank 1 $ 220,000 12 Bank 2 13 Bank 3 14 Bank 4 15 Total Bank Loans $ 220,000 16 17 Other Loans Available 18 Source 1 Loan from investor 19 Source 2 20 Total Other Loans $ 21 22 Sources of Capital 23 Owners' and other investments $ 20,000 24 Bank loans 220,000 25 Other loans 26 Total Source of Funds $ 240,000 27 28 Security and Collateral for Loan Proposal Beginning Expenses Sources of Capital Cash Flow Profit-Loss Analysis zady + Type here to search O Bte 19000 B $27,000 D E F G Notes on Preparation Note: Average retail building space is about $16-S20 per sqaure fe of buying a building we will rent one out. No construction cost since is already there. Wont be a lot of supplies in stock, becuase technicians will be brir equipment to customers home when they install. I based the numbers off how much it cost to own a franchise AT& the buyer anywhere from 200-250 thousand. $ 27,000 3 4 Buildings/Real Estate 5 Purchase 6 Construction 7 Remodeling 8 Other 9 Total Buildings/Real Estate 0 1 Capital Equipment List 2 Furniture 3 Equipment 4 Fixtures 5 Machinery 3 Other 7 Total Capital Equipment 3 Location and Admin Expenses Rent & Related Costs Utility deposits Legal and accounting fees Prepaid insurance Beginning Expenses sources of Capital Cash Flow $15,000 $10,000 $4,000 $ 29,000 $2,333 $2,000 $1,000 $3,600 Profit-Loss Analysis B52 19000 $45,000 $ 53,933 $15,000 Cable boxes Modems remote controllers 24 Pre-opening or pre-implementing salaries 25 Other 26 Total Location and Admin Expenses 27 28 Opening Inventory / Supplies Needed 29 Category 1 50 Category 2 1 Category 3 2 Category 4 3 Category 5 4 Total Inventory 5 Advertising and Promotional Expenses Advertising Signage Printing Travel/entertainment Other/additional categories Total Advertising/Promotional Expenses $ 15,000 7 $60,000 $1,000 $15,000 $3,000 $4,000 83,000 $ Other Expenses Beginning Expenses Sources of Capital Cash Flow Profit-Loss Analysis fi 19000 $ 83,000 $10,000 A Total Advertising/Promotional Expenses 3 Other Expenses Other expense 1 = Other expense 2 Other expense 3 Other expense 4 Other expense 5 Total Other Expenses $ 10,000 Reserve for Contingencies $19,000 Summary Statement of Beginning Expenses $ Beginning Expenses Buildings/real estate Capital equipment Location/administration expenses Onaninainuantan, Beginning Expenses Sources of Capital Cash Flow 27,000 29,000 53,933 16 non Profit -Loss Analysis Type here to search O RI e Copy Condtional fomunas con $ 99 -Cathco Cash M N 0 F Cash Flow Projections de formation only in the yelowiges Fiscal Year Starts (Month/Year: June 2001 2021 Beginning 30201 #VALUE! EVALUE WVALUE VALUES VALUE WVALUE EVALUE! EVALUE VALUE EVALUES 00 $0.00 Summary Cash Aslate start of the month Net Cash Flow Cash Balance end of the month) 0 50.00 $0.00 $0.00 3000 $0.00 $0.00 50 00 S000 SO 000 000 SO S000 000 300 00 3000 S000 30 00 $0.00 000 DO 5000 $0.00 50.00 50.00 Cash Received Cash from cables Loan Inwest Received Other Other Other Other Other Subtotal Cash Received 50.00 $0.00 19.00 $0.00 50.00 50.00 SO DO $0.00 $0.00 $0.00 $0.00 $0.00 Expenditures: Purchases Gross Wages Supplies Beginning Expenses Sources of Cape Cash Flow Pro Los Analys GO f 1057 PM 19/2020 O > Type here to search - 10 - AA== BIU - - 4 - Merge Center $ - % 9 Forang Stes -Cash Cash 0 G H N Cash from Receivables Loan Investment Received Other Other On Other Subtotal Cash Received $0.00 $0.00 50.00 $0.00 $0.00 $0.00 $0.00 $0.00 10.00 5000 $0.00 $0.00 Expenditures: Purchase Gross Wages Supplies Advertising Repair intenance Rent Us Principal Repayment of borrowing Longorm Lite Repayment Long to Asses Purchase One Startup Costs Other Other 50.00 $0.00 $0.00 30.00 10.00 19.00 50.00 0.00 50.00 10.00 Subtotal Cash Expenditures $0.00 10.00 Notes on Preparation Note: Click inbox o ad nos oriences to where you obtained Beginning entesources of Cape Cash Flow POLO Aays COS 10:57 PM 0 BIL - ** 15 ng so 19000 B $27,000 D E F G Notes on Preparation Note: Average retail building space is about $16-S20 per sqaure fe of buying a building we will rent one out. No construction cost sinc is already there. Wont be a lot of supplies in stock, becuase technicians will be brir equipment to customers home when they install. I based the numbers off how much it cost to own a franchise AT8 the buyer anywhere from 200-250 thousand. $ 27,000 3 4 Buildings/Real Estate 5 Purchase 6 Construction 7 Remodeling 8 Other 9 Total Buildings/Real Estate 0 1 Capital Equipment List 2 Furniture 3 Equipment 4 Fixtures 5 Machinery Other 7 Total Capital Equipment 3 Location and Admin Expenses Rent & Related Costs Utility deposits Legal and accounting fees Prepaid insurance Beginning Expenses sources of Capital Cash low $15,000 $10,000 $4,000 $ 29,000 $2,333 $2,000 $1,000 $3,600 Prohit-Loss Analysis B52 19000 $45,000 $ 53,933 $15,000 Cable boxes Modems remote controllers 24 Pre-opening or pre-implementing salaries 25 Other 26 Total Location and Admin Expenses 27 28 Opening Inventory / Supplies Needed 29 Category 1 50 Category 2 -1 Category 3 2 Category 4 3 Category 5 4 Total Inventory 5 Advertising and Promotional Expenses Advertising Signage Printing Travel/entertainment Other/additional categories Total Advertising/Promotional Expenses $ 15,000 $60,000 $1,000 $15,000 $3,000 $4,000 83,000 $ Other Expenses Beginning Expenses Sources of Capital Cash Flow Profit-Loss Analysis fi 19000 $ 83,000 $10,000 A Total Advertising/Promotional Expenses 3 Other Expenses Other expense 1 = Other expense 2 Other expense 3 Other expense 4 Other expense 5 Total Other Expenses $ 10,000 Reserve for Contingencies $19,000 Summary Statement of Beginning Expenses $ Beginning Expenses Buildings/real estate Capital equipment Location/administration expenses Anoninainuantan Beginning Expenses Sources of Capital Cash Flow 27,000 29,000 53,933 16 non Profit -Loss Analysis Type here to search at e D B $19,000 Reserve for Contingencies Summary Statement of Beginning Expenses $ Beginning Expenses Buildings/real estate Capital equipment Location/administration expenses Opening inventory Advertising/promotional expenses Other expenses Contingency fund Total Startup Expenses 27,000 29,000 53,933 15,000 83,000 10,000 19,000 236,933 $ Beginning Expenses Sources of Capital Cash Flow Profit-Loss Analysis Type here to search ORP e B D E 8 Total Investment $ 240,000 would think he would have good i 9 10 Bank Loans Needed 11 Bank 1 $ 220,000 12 Bank 2 13 Bank 3 14 Bank 4 15 Total Bank Loans $ 220,000 16 17 Other Loans Available 18 Source 1 Loan from investor 19 Source 2 20 Total Other Loans $ 21 22 Sources of Capital 23 Owners' and other investments $ 20,000 24 Bank loans 220,000 25 Other loans 26 Total Source of Funds $ 240,000 27 28 Security and Collateral for Loan Proposal Beginning Expenses Sources of Capital Cash Flow Profit-Loss Analysis zady + Type here to search O Bte 19000 B $27,000 D E F G Notes on Preparation Note: Average retail building space is about $16-S20 per sqaure fe of buying a building we will rent one out. No construction cost since is already there. Wont be a lot of supplies in stock, becuase technicians will be brir equipment to customers home when they install. I based the numbers off how much it cost to own a franchise AT& the buyer anywhere from 200-250 thousand. $ 27,000 3 4 Buildings/Real Estate 5 Purchase 6 Construction 7 Remodeling 8 Other 9 Total Buildings/Real Estate 0 1 Capital Equipment List 2 Furniture 3 Equipment 4 Fixtures 5 Machinery 3 Other 7 Total Capital Equipment 3 Location and Admin Expenses Rent & Related Costs Utility deposits Legal and accounting fees Prepaid insurance Beginning Expenses sources of Capital Cash Flow $15,000 $10,000 $4,000 $ 29,000 $2,333 $2,000 $1,000 $3,600 Profit-Loss Analysis B52 19000 $45,000 $ 53,933 $15,000 Cable boxes Modems remote controllers 24 Pre-opening or pre-implementing salaries 25 Other 26 Total Location and Admin Expenses 27 28 Opening Inventory / Supplies Needed 29 Category 1 50 Category 2 1 Category 3 2 Category 4 3 Category 5 4 Total Inventory 5 Advertising and Promotional Expenses Advertising Signage Printing Travel/entertainment Other/additional categories Total Advertising/Promotional Expenses $ 15,000 7 $60,000 $1,000 $15,000 $3,000 $4,000 83,000 $ Other Expenses Beginning Expenses Sources of Capital Cash Flow Profit-Loss Analysis fi 19000 $ 83,000 $10,000 A Total Advertising/Promotional Expenses 3 Other Expenses Other expense 1 = Other expense 2 Other expense 3 Other expense 4 Other expense 5 Total Other Expenses $ 10,000 Reserve for Contingencies $19,000 Summary Statement of Beginning Expenses $ Beginning Expenses Buildings/real estate Capital equipment Location/administration expenses Onaninainuantan, Beginning Expenses Sources of Capital Cash Flow 27,000 29,000 53,933 16 non Profit -Loss Analysis Type here to search O RI e Copy Condtional fomunas con $ 99 -Cathco Cash M N 0 F Cash Flow Projections de formation only in the yelowiges Fiscal Year Starts (Month/Year: June 2001 2021 Beginning 30201 #VALUE! EVALUE WVALUE VALUES VALUE WVALUE EVALUE! EVALUE VALUE EVALUES 00 $0.00 Summary Cash Aslate start of the month Net Cash Flow Cash Balance end of the month) 0 50.00 $0.00 $0.00 3000 $0.00 $0.00 50 00 S000 SO 000 000 SO S000 000 300 00 3000 S000 30 00 $0.00 000 DO 5000 $0.00 50.00 50.00 Cash Received Cash from cables Loan Inwest Received Other Other Other Other Other Subtotal Cash Received 50.00 $0.00 19.00 $0.00 50.00 50.00 SO DO $0.00 $0.00 $0.00 $0.00 $0.00 Expenditures: Purchases Gross Wages Supplies Beginning Expenses Sources of Cape Cash Flow Pro Los Analys GO f 1057 PM 19/2020 O > Type here to search - 10 - AA== BIU - - 4 - Merge Center $ - % 9 Forang Stes -Cash Cash 0 G H N Cash from Receivables Loan Investment Received Other Other On Other Subtotal Cash Received $0.00 $0.00 50.00 $0.00 $0.00 $0.00 $0.00 $0.00 10.00 5000 $0.00 $0.00 Expenditures: Purchase Gross Wages Supplies Advertising Repair intenance Rent Us Principal Repayment of borrowing Longorm Lite Repayment Long to Asses Purchase One Startup Costs Other Other 50.00 $0.00 $0.00 30.00 10.00 19.00 50.00 0.00 50.00 10.00 Subtotal Cash Expenditures $0.00 10.00 Notes on Preparation Note: Click inbox o ad nos oriences to where you obtained Beginning entesources of Cape Cash Flow POLO Aays COS 10:57 PM 0 BIL - ** Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started