401488374 - Business Financial

xlsx

School

Al – Hamd College of Professional Education Hyderabad *

*We aren’t endorsed by this school

Course

25

Subject

Management

Date

Nov 24, 2024

Type

xlsx

Pages

61

Uploaded by HighnessEnergy7678

Report
Worksheet Instructions: o You will have to comple o Complete the cells in blu o Do not delete any colum o Complete the workshee Worksheet #1: Company Info
Worksheet #2: Sales Projections Worksheet #3: Inventory
Worksheet #4: Marketing Expenses Worksheet #5: Staff Expenses Worksheet #6: Capital Expenditures
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
  • Access to all documents
  • Unlimited textbook solutions
  • 24/7 expert homework help
Worksheet #7 Capital Investments and Loans Worksheet #8: Income Statement Worksheet #9: Cash Flow Statement Worksheet 10: Balance Sheet Worksheet 11: Break-Even
Guide to Complete the Company Financials Excel Template Data Entry ete the financials for the first two years in business. ue, as applicable. The cells in black will auto calculate. mns, rows, cells in the Excel document. Just input the information. If you need to make a change, highlight the cell and type o ets in order (after completing week 4 requirements). Provide the basic company information in this worksheet. Line 3: Enter the company name. Line 4: Your business will start in January of the current year. Line 5: Enter the current year. Note: You will have to update the years at the top of every worksheet, as needed. Line 7: Use the drop-down to select the number of product/ service lines you plan to have (up to 5). • The product/ service lines are the different categories of products or services you are selling (flavors, types of products). a. Example of product lines: Your business sells chips in 3 flavors (regular, cheese, barbecue). Each flavor is a product line. b. Example of service lines: Your business is a daycare. Your services are full-day care, half-day care, hourly care. Each type o • The benefits and financial assumptions can be adjusted or left as completed. Line 14: Enter the balance in your bank account as you open your business. The assumption is that you had made some sales officially.
In this worksheet you will input the sales projections, the source(s) of your revenue. • Speculate how much your company will grow and how much you will sell. • You will need to reach total gross sales (line 40) of over $1 million by the end of the second year. Product/ Service Lines: Specify the product/ service lines in the first column to the left. Unit Volume= how much of each product or service you are selling (calculated as number of items, services, hours worked). o Under Calculations: 2%: represents MONTHLY VOLUME GROWTH RATE. The Worksheets automatically increase the volume in each month on this line using the rate you enter here. You can adjust leave as is. You can also enter each cell's value by hand, if you prefer, which makes sense if you need to show ups and downs in sales due Unit Price= the price per product or service or hourly cost (if you measure sales in number of hours worked). o Under Calculations: 2.5% represents the YEARLY PRICE GROWTH RATE. This cell shows how much you plan to increase prices each year. It is not per month because consumers typically don't stand fo full year, we increase the unit price by X%, then again after 2 years, etc. The default is 2.5% per year, close to inflation rates). As a convenience, the Worksheets can automatically increase the rate you enter here. You can adjust this per your preferences or leave as is. You can also enter each cell's value by hand, if you prefer, which makes sense if you need to show ups and downs in sales due Cost of Goods Sold: o Approximately what percentage of your product's sale price will be spent on manufacturing? If you are a reseller or r product's sale price will be spent on buying the product from your distributor? o This is set at 50% but you can adjust as needed. o If you have a service-based business and do not sell any physical items, the cost of goods sold can be zero, indicatin as well. In this worksheet, you will record your inventory expenses. • For each product line, enter the dollar amount you will spend each period on inventory, identifying the items in the inven • You must complete this for years one and two in business. • If yours is a service business, your inventory may be zero, so you can ignore this worksheet. Cost of Goods Sold: This Cost of Goods number is pulled over from your Sales Projections and shows how much It will cost you sell each month. It's here simply to aid you in determining how much inventory you need to purchase. Items/Parts #: Identify what the inventory consists of. • Example: if you make chips, the items in your inventory could be ingredients, bags, cartons. In the first column, you will id costs per unit/ item. If the chips cost $4 per bag, and COGS is set at 50%, the COGS per bag/ unit would be $2. You then can de unit $0.5, cartons/ unit $0.5. You will then enter this information in the appropriate column for the inventory to calculate each You will need to complete this for each product lines, both in years one and two. • We automatically increase the amount of inventory needed for each part at the same rate as COGS grows on the SalesPro You can override the automatically entered values by entering in actuals in the blue cells. Total Inventory Expense: This should equal the Cost of Goods Sold each month for each product line. This means you will pu the products you plan to sell as projected on the sales projections.
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
  • Access to all documents
  • Unlimited textbook solutions
  • 24/7 expert homework help
In this worksheet, you will input your marketing expenses. • Input the marketing expenses for your company as reflected in the marketing budget table in week 4 discussion. The tabl alignment. • Leave at zero any marketing vehicles you do not plan to use. On this worksheet you will account for every paid employee using the appropriate lines for the six categories of employees. • You will need to have more employee and managers in the second year than in the first (your sales are increasing). # Salaried Employees: Enter the number of full-time employees you expect to have working for you in this category during this For part-time employees, enter their information below under "Part-time / Hourly Employees". Avg Salary per employee: Enter the amount you expect to pay each employee in this category this month. The salaries may va average salary/ month. The Worksheets will multiply the number of employees (from the line above) with this number to gene and taxes, below). Benefits (across all employees): This value is calculated using the number you entered on the "Company Info" worksheet and entered above. Payroll Taxes: Are auto calculated based on the information you entered in the CompanyInfo worksheet. In this worksheet you will track capital expenditures and manage depreciation for those expenditures. Facilities: Facilities include land, buildings (only if purchased), building upgrades, fixtures, etc. If you rent the facility, the rent e income statement under expenses/ rent. Note: You can combine items into groups and enter data for the entire group on a single line. For example: furniture, 5 comput Item Name: Enter the cost of the item(s) here. This will be used to calculate depreciation and you will need to input this inform Purchase Date: o Month: Enter the month you will purchase the item(s). Note: When entering dates on this worksheet, make sure that they don't fall prior to your current startup date (as entered on t o Year: Enter the year you will purchase the item(s). Years of Service: Enter the number of years you will use the item(s) before it wears out, you retire it, or sell it. You can then calculate the depreciation using the calculator (link in the worksheet). You can also expense items in the year they are purchased. Salvage Value: This is the value of the item at the time you stop using it, or the price you might receive for it if you sell it. For example, a $1000 desk might be worth $300 when you sell it after five years of use. You would enter $300 in this cell. If you will not be depreciating the item (the Years of Service column is set to 1 year), you can ignore this. Equipment: Equipment includes machinery, furniture, vehicles, etc. Computer Hardware/Software: Includes PCs, servers, monitors, printers, scanners, other peripherals, and software application Telecommunications: Telecommunications includes phone systems, fax machines, etc. Land: Land purchases are not depreciable.
In this worksheet, you will record the funding you have (equity, loans) and investments in your business. Equity: • Input the savings or capital you invest in the business. • You must also input the funds you plan to raise from the investors (required). For investor funds you must include in para for these funds (portion of the business e. g 10%). Loans: Unlike equity capital investments, lenders are typically not interested in purchasing shares in your company--they simpl schedule, with interest. Lenders can include banks and family members. • Loan Source Name (e.g., Bank of America). o Loan Period: Enter the term (length) of the loan in MONTHS. For example, if this will be a three-year loan, enter 36 he o Interest Rate: Enter the loan's annual interest rate. o Use the calculator (link in the worksheet) to calculate the monthly loan payment and interest. You will input the pay This is your profit and loss statement, showing your revenue and expenses. Enter the cost of your expenses: rent- (if not purchasing building), maintenance, insurance, telephone, utilities, office supplies. Line 15: Depreciation - You will calculate this on the Capital Expenditures worksheet if you depreciate any items. Click on the c appropriate numbers. A depreciation schedule will be calculated. You will enter the depreciation numbers in the income statem Line 21: Interest on loans -You will calculate this on the Capital Investments worksheet, if you plan to have any loans. Click on t appropriate numbers based on your loan information. A loan payment and interest schedule will be calculated. You will extract the income statement. Note: You must record profits each month. This worksheet shows the sources of cash and the flow of cash (in and out). Line 6: Equity Capital Investments: Input the equity investments you entered in the Capital Fund Investment sheet. Expenditures: Calculate the totals for each month based on the capital expenses you input on the Capital Expenditures worksh Line 16: Loan Payments: You will calculate this on the Capital Investments worksheet, if you plan to have any loans. Click on th appropriate numbers based on your loan information. A loan payment and interest schedule will be calculated. You will extract Line 17: Income tax payments: Take the numbers from the provisions for taxes on income and pay off the amount under the t taxes paid on the cash flow statement and the provisions for taxes on income from the income statement should match. This worksheet summarizes a company's assets, liabilities, and shareholders' equity at a specific point in time. Fixed Assets: Complete this section using the information input in the Capital Expenditures worksheet. Liabilities: Complete this section using the information you input in the Capital Investment worksheets under loans. This worksheet shows the amount of sales you will need to make each month to break even (you are not making money, but y This worksheet will automatically populate from the other completed worksheets.
Company Financials Categories Company Name Company start date (Month) Company start date (Year) Number of major product/service lines. Company Benefits for Personnel Company benefits for each part-time employees (cost/year) Estimate wage increases on an annual basis. (salaried & hourly) Percentages of employee salary set aside for payroll taxes. Financial Assumptions Cash Flow Statement opening balance. Number of major product/service lines. (You can have sales for up to 5 products/services) Company benfits for each full-time employees (cost/year). (medical insurance, etc)
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
  • Access to all documents
  • Unlimited textbook solutions
  • 24/7 expert homework help
Information Instructions D&D’s Boutique Enter your Company's name. January 2023 1 $5,000.00 $1,200.00 3.50% 15.00% $5,000.00 Enter the year you started your company. (Current Year) Enter your number of products/service/categories. Approximately how much do you expect to spend per year on benefits for each Salaried/Full Time employee (medical insurance, etc.)? Approximately how much do you expect to spend per year on benefits for each Hourly/Part-Time employee (mediacal insurance, etc.)? Enter your yearly estimated wage increase percentage. Enter the percentage of salaries you will set aside for payroll taxes. Enter the opening Balance in your baknk account on the first day of business. This number will be the Cash Flow Statement opening balance.
Sales Projections 2023 Calculations January February Product Line 1 - Casual Wear (Mens) Unit Volume 2.00% 1,000.00 1,020.00 Unit Price 2.50% $20.00 $20.00 Gross Sales $20,000.00 $20,400.00 (Cost of Goods Sold) 50.00% $10,000.00 $10,200.00 Gross Profit $10,000.00 $10,200.00 Product Line 2-Casual Wear (Women) Unit Volume 2.00% 1,500.00 1,530.00 Unit Price 2.50% $30.00 $30.00 Gross Sales $45,000.00 $45,900.00 (Cost of Goods Sold) 50.00% $22,500.00 $22,950.00 Gross Profit $22,500.00 $22,950.00 Product Line 3-Athleisure Unit Volume 2.00% 500.00 510.00 Unit Price 2.50% $30.00 $30.00 Gross Sales $15,000.00 $15,300.00 (Cost of Goods Sold) 50.00% $7,500.00 $7,650.00 Gross Profit $7,500.00 $7,650.00 Product Line 4-Maxi Casuals Unit Volume 2.00% 500.00 510.00 Unit Price 2.50% $40.00 $40.00 Gross Sales $20,000.00 $20,400.00 (Cost of Goods Sold) 50.00% $10,000.00 $10,200.00 Gross Profit $10,000.00 $10,200.00 Product Line 5-Oversized Casuals Unit Volume 2.00% 1,000.00 1,020.00 Unit Price 2.50% $50.00 $50.00 Gross Sales $50,000.00 $51,000.00 (Cost of Goods Sold) 50.00% $25,000.00 $25,500.00 Gross Profit $25,000.00 $25,500.00 Totals for All Product Lines Total Unit Volume 4,500.00 4,590.00 Total Gross Sales $150,000.00 $153,000.00 (Total Cost of Goods Sold) $75,000.00 $76,500.00 Total Gross Profit $75,000.00 $76,500.00
March April May June 1,040.40 1,061.21 1,082.43 1,104.08 $20.00 $20.00 $20.00 $20.00 $20,808.00 $21,224.16 $21,648.64 $22,081.62 $10,404.00 $10,612.08 $10,824.32 $11,040.81 $10,404.00 $10,612.08 $10,824.32 $11,040.81 1,560.60 1,591.81 1,623.65 1,656.12 $30.00 $30.00 $30.00 $30.00 $46,818.00 $47,754.36 $48,709.45 $49,683.64 $23,409.00 $23,877.18 $24,354.72 $24,841.82 $23,409.00 $23,877.18 $24,354.72 $24,841.82 520.20 530.60 541.22 552.04 $30.00 $30.00 $30.00 $30.00 $15,606.00 $15,918.12 $16,236.48 $16,561.21 $7,803.00 $7,959.06 $8,118.24 $8,280.61 $7,803.00 $7,959.06 $8,118.24 $8,280.61 520.20 530.60 541.22 552.04 $40.00 $40.00 $40.00 $40.00 $20,808.00 $21,224.16 $21,648.64 $22,081.62 $10,404.00 $10,612.08 $10,824.32 $11,040.81 $10,404.00 $10,612.08 $10,824.32 $11,040.81 1,040.40 1,061.21 1,082.43 1,104.08 $50.00 $50.00 $50.00 $50.00 $52,020.00 $53,060.40 $54,121.61 $55,204.04 $26,010.00 $26,530.20 $27,060.80 $27,602.02 $26,010.00 $26,530.20 $27,060.80 $27,602.02 4,681.80 4,775.44 4,870.94 4,968.36 $156,060.00 $159,181.20 $162,364.82 $165,612.12 $78,030.00 $79,590.60 $81,182.41 $82,806.06 $78,030.00 $79,590.60 $81,182.41 $82,806.06
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
  • Access to all documents
  • Unlimited textbook solutions
  • 24/7 expert homework help
July August September October 1,126.16 1,148.69 1,171.66 1,195.09 $20.00 $20.00 $20.00 $20.00 $22,523.25 $22,973.71 $23,433.19 $23,901.85 $11,261.62 $11,486.86 $11,716.59 $11,950.93 $11,261.62 $11,486.86 $11,716.59 $11,950.93 1,689.24 1,723.03 1,757.49 1,792.64 $30.00 $30.00 $30.00 $30.00 $50,677.31 $51,690.86 $52,724.67 $53,779.17 $25,338.65 $25,845.43 $26,362.34 $26,889.58 $25,338.65 $25,845.43 $26,362.34 $26,889.58 563.08 574.34 585.83 597.55 $30.00 $30.00 $30.00 $30.00 $16,892.44 $17,230.29 $17,574.89 $17,926.39 $8,446.22 $8,615.14 $8,787.45 $8,963.19 $8,446.22 $8,615.14 $8,787.45 $8,963.19 563.08 574.34 585.83 597.55 $40.00 $40.00 $40.00 $40.00 $22,523.25 $22,973.71 $23,433.19 $23,901.85 $11,261.62 $11,486.86 $11,716.59 $11,950.93 $11,261.62 $11,486.86 $11,716.59 $11,950.93 1,126.16 1,148.69 1,171.66 1,195.09 $50.00 $50.00 $50.00 $50.00 $56,308.12 $57,434.28 $58,582.97 $59,754.63 $28,154.06 $28,717.14 $29,291.48 $29,877.31 $28,154.06 $28,717.14 $29,291.48 $29,877.31 5,067.73 5,169.09 5,272.47 5,377.92 $168,924.36 $172,302.85 $175,748.91 $179,263.89 $84,462.18 $86,151.43 $87,874.45 $89,631.94 $84,462.18 $86,151.43 $87,874.45 $89,631.94
2024 November December TOTAL January 1,218.99 1,243.37 13,412.09 1,268.24 $20.00 $20.00 $20.50 $24,379.89 $24,867.49 $268,241.79 $25,998.96 $12,189.94 $12,433.74 $134,120.90 $12,999.48 $12,189.94 $12,433.74 $134,120.90 $12,999.48 1,828.49 1,865.06 20,118.13 1,902.36 $30.00 $30.00 $30.75 $54,854.75 $55,951.84 $603,544.04 $58,497.65 $27,427.37 $27,975.92 $301,772.02 $29,248.83 $27,427.37 $27,975.92 $301,772.02 $29,248.83 609.50 621.69 6,706.04 634.12 $30.00 $30.00 $30.75 $18,284.92 $18,650.61 $201,181.35 $19,499.22 $9,142.46 $9,325.31 $100,590.67 $9,749.61 $9,142.46 $9,325.31 $100,590.67 $9,749.61 609.50 621.69 6,706.04 634.12 $40.00 $40.00 $41.00 $24,379.89 $24,867.49 $268,241.79 $25,998.96 $12,189.94 $12,433.74 $134,120.90 $12,999.48 $12,189.94 $12,433.74 $134,120.90 $12,999.48 1,218.99 1,243.37 13,412.09 1,268.24 $50.00 $50.00 $51.25 $60,949.72 $62,168.72 $670,604.49 $64,997.39 $30,474.86 $31,084.36 $335,302.24 $32,498.70 $30,474.86 $31,084.36 $335,302.24 $32,498.70 5,485.47 5,595.18 60,354.40 5,707.09 $182,849.16 $186,506.15 $2,011,813.46 $194,992.18 $91,424.58 $93,253.07 $1,005,906.73 $97,496.09 $91,424.58 $93,253.07 $1,005,906.73 $97,496.09
February March April May 1,293.61 1,319.48 1,345.87 1,372.79 $20.50 $20.50 $20.50 $20.50 $26,518.94 $27,049.31 $27,590.30 $28,142.11 $13,259.47 $13,524.66 $13,795.15 $14,071.05 $13,259.47 $13,524.66 $13,795.15 $14,071.05 1940.41 1979.22 2018.80 2059.18 $30.75 $30.75 $30.75 $30.75 $59,667.61 $60,860.96 $62,078.18 $63,319.74 $29,833.80 $30,430.48 $31,039.09 $31,659.87 $29,833.80 $30,430.48 $31,039.09 $31,659.87 646.80 659.74 672.93 686.39 $30.75 $30.75 $30.75 $30.75 $19,889.20 $20,286.99 $20,692.73 $21,106.58 $9,944.60 $10,143.49 $10,346.36 $10,553.29 $9,944.60 $10,143.49 $10,346.36 $10,553.29 646.80 659.74 672.93 686.39 $41.00 $41.00 $41.00 $41.00 $26,518.94 $27,049.31 $27,590.30 $28,142.11 $13,259.47 $13,524.66 $13,795.15 $14,071.05 $13,259.47 $13,524.66 $13,795.15 $14,071.05 1293.61 1319.48 1345.87 1372.79 $51.25 $51.25 $51.25 $51.25 $66,297.34 $67,623.29 $68,975.75 $70,355.27 $33,148.67 $33,811.64 $34,487.88 $35,177.63 $33,148.67 $33,811.64 $34,487.88 $35,177.63 5,821.23 5,937.65 6,056.41 6,177.54 $198,892.02 $202,869.86 $206,927.26 $211,065.80 $99,446.01 $101,434.93 $103,463.63 $105,532.90 $99,446.01 $101,434.93 $103,463.63 $105,532.90
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
  • Access to all documents
  • Unlimited textbook solutions
  • 24/7 expert homework help
June July August September 1,400.24 1,428.25 1,456.81 1,485.95 $20.50 $20.50 $20.50 $20.50 $28,704.95 $29,279.05 $29,864.63 $30,461.92 $14,352.47 $14,639.52 $14,932.31 $15,230.96 $14,352.47 $14,639.52 $14,932.31 $15,230.96 2100.36 2142.37 2185.22 2228.92 $30.75 $30.75 $30.75 $30.75 $64,586.14 $65,877.86 $67,195.42 $68,539.32 $32,293.07 $32,938.93 $33,597.71 $34,269.66 $32,293.07 $32,938.93 $33,597.71 $34,269.66 700.12 714.12 728.41 742.97 $30.75 $30.75 $30.75 $30.75 $21,528.71 $21,959.29 $22,398.47 $22,846.44 $10,764.36 $10,979.64 $11,199.24 $11,423.22 $10,764.36 $10,979.64 $11,199.24 $11,423.22 700.12 714.12 728.41 742.97 $41.00 $41.00 $41.00 $41.00 $28,704.95 $29,279.05 $29,864.63 $30,461.92 $14,352.47 $14,639.52 $14,932.31 $15,230.96 $14,352.47 $14,639.52 $14,932.31 $15,230.96 1400.24 1428.25 1456.81 1485.95 $51.25 $51.25 $51.25 $51.25 $71,762.37 $73,197.62 $74,661.57 $76,154.80 $35,881.19 $36,598.81 $37,330.79 $38,077.40 $35,881.19 $36,598.81 $37,330.79 $38,077.40 6,301.09 6,427.11 6,555.65 6,686.76 $215,287.12 $219,592.86 $223,984.72 $228,464.41 $107,643.56 $109,796.43 $111,992.36 $114,232.21 $107,643.56 $109,796.43 $111,992.36 $114,232.21
October November December TOTAL 1,515.67 1,545.98 1,576.90 17,009.77 $20.50 $20.50 $20.50 $31,071.16 $31,692.58 $32,326.43 $348,700.34 $15,535.58 $15,846.29 $16,163.22 $174,350.17 $15,535.58 $15,846.29 $16,163.22 $174,350.17 2273.50 2318.97 2365.35 25514.66 $30.75 $30.75 $30.75 $69,910.11 $71,308.31 $72,734.48 $784,575.77 $34,955.06 $35,654.16 $36,367.24 $392,287.88 $34,955.06 $35,654.16 $36,367.24 $392,287.88 757.83 772.99 788.45 8504.89 $30.75 $30.75 $30.75 $23,303.37 $23,769.44 $24,244.83 $261,525.26 $11,651.69 $11,884.72 $12,122.41 $130,762.63 $11,651.69 $11,884.72 $12,122.41 $130,762.63 757.83 772.99 788.45 8504.89 $41.00 $41.00 $41.00 $31,071.16 $31,692.58 $32,326.43 $348,700.34 $15,535.58 $15,846.29 $16,163.22 $174,350.17 $15,535.58 $15,846.29 $16,163.22 $174,350.17 1515.67 1545.98 1576.90 17009.77 $51.25 $51.25 $51.25 $77,677.90 $79,231.46 $80,816.09 $871,750.85 $38,838.95 $39,615.73 $40,408.04 $435,875.43 $38,838.95 $39,615.73 $40,408.04 $435,875.43 6,820.50 6,956.91 7,096.05 76,543.98 $233,033.70 $237,694.37 $242,448.26 $2,615,252.56 $116,516.85 $118,847.19 $121,224.13 $1,307,626.28 $116,516.85 $118,847.19 $121,224.13 $1,307,626.28
Inventory 2023 January February Product/ Service Line 1 Cost Per Unit Cost of Goods Sold $10.00 $10,000.00 $10,200.00 Inventory Item 1 - T shirts $10.00 $10,000.00 $10,200.00 Inventory Item 2 - Jeans $10.00 $10,000.00 $10,200.00 Inventory Item 3 - Pants $10.00 $10,000.00 $10,200.00 Inventory Expense $30,000.00 $30,600.00 Product/Service Line 2 Cost of Goods Sold $15.00 $22,500.00 $22,950.00 Inventory Item 1-Sleeveless $15.00 $22,500.00 $22,950.00 Inventory Item 2-Legging $12.00 $18,000.00 $18,360.00 Inventory Item 3-Shorts $15.00 $22,500.00 $22,500.00 Inventory Expense $63,000.00 $63,810.00 Product/ Service Line 3 Cost of Goods Sold $15.00 $7,500.00 $7,650.00 Inventory Item 1-Leggies $12.00 $6,000.00 $6,120.00 Inventory Item 2-Yoga pants $10.00 $5,000.00 $5,100.00 Inventory Item 3-Sneakers $10.00 $5,000.00 $5,100.00 Inventory Expense $16,000.00 $16,320.00 Product/Service Line 4 Cost of Goods Sold $20.00 $10,000.00 $10,200.00 Inventory Item 1-Maxi Dress $12.00 $6,000.00 $6,120.00 Inventory Item 2- Maxi Dress (mini) $12.00 $6,000.00 $6,120.00 Inventory Item 3 $0.00 $0.00 $0.00 Inventory Expense $12,000.00 $12,240.00 Product/Service Line 5 Cost of Goods Sold $25.00 $25,000.00 $25,500.00 Inventory Item 1 -Jacket $20.00 $20,000.00 $20,400.00 Inventory Item 2 - Sweaters $15.00 $15,000.00 $15,300.00 Inventory Item 3 -Jeans $12.00 $12,000.00 $12,240.00 Inventory Expense $47,000.00 $47,940.00 $168,000.00 $170,910.00 Total Monthly Inventory Expense
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
  • Access to all documents
  • Unlimited textbook solutions
  • 24/7 expert homework help
March April May June July $10,404.00 $10,612.08 $10,824.32 $11,040.81 $11,261.62 $10,404.00 $10,612.08 $10,824.32 $11,040.81 $11,261.62 $10,404.00 $10,612.08 $10,824.32 $11,040.81 $11,261.62 $10,404.00 $10,612.08 $10,824.32 $11,040.81 $11,261.62 $31,212.00 $31,836.24 $32,472.96 $33,122.42 $33,784.87 $23,409.00 $23,877.18 $24,354.72 $24,841.82 $25,338.65 $23,409.00 $23,877.18 $24,354.72 $24,841.82 $25,338.65 $18,727.20 $19,101.74 $19,483.78 $19,873.45 $20,270.92 $22,500.00 $22,500.00 $22,500.00 $22,500.00 $22,500.00 $64,636.20 $65,478.92 $66,338.50 $67,215.27 $68,109.58 $7,803.00 $7,959.06 $8,118.24 $8,280.61 $8,446.22 $6,242.40 $6,367.25 $6,494.59 $6,624.48 $6,756.97 $5,202.00 $5,306.04 $5,412.16 $5,520.40 $5,630.81 $5,202.00 $5,306.04 $5,412.16 $5,520.40 $5,630.81 $16,646.40 $16,979.33 $17,318.91 $17,665.29 $18,018.60 $10,404.00 $10,612.08 $10,824.32 $11,040.81 $11,261.62 $6,242.40 $6,367.25 $6,494.59 $6,624.48 $6,756.97 $6,242.40 $6,367.25 $6,494.59 $6,624.48 $6,756.97 $0.00 $0.00 $0.00 $0.00 $0.00 $12,484.80 $12,734.50 $12,989.19 $13,248.97 $13,513.95 $26,010.00 $26,530.20 $27,060.80 $27,602.02 $28,154.06 $20,808.00 $21,224.16 $21,648.64 $22,081.62 $22,523.25 $15,606.00 $15,918.12 $16,236.48 $16,561.21 $16,892.44 $12,484.80 $12,734.50 $12,989.19 $13,248.97 $13,513.95 $48,898.80 $49,876.78 $50,874.31 $51,891.80 $52,929.63 $173,878.20 $176,905.76 $179,993.88 $183,143.76 $186,356.63
August September October November December $11,486.86 $11,716.59 $11,950.93 $12,189.94 $12,433.74 $11,486.86 $11,716.59 $11,950.93 $12,189.94 $12,433.74 $11,486.86 $11,716.59 $11,950.93 $12,189.94 $12,433.74 $11,486.86 $11,716.59 $11,950.93 $12,189.94 $12,433.74 $34,460.57 $35,149.78 $35,852.78 $36,569.83 $37,301.23 $25,845.43 $26,362.34 $26,889.58 $27,427.37 $27,975.92 $25,845.43 $26,362.34 $26,889.58 $27,427.37 $27,975.92 $20,676.34 $21,089.87 $21,511.67 $21,941.90 $22,380.74 $22,500.00 $22,500.00 $22,500.00 $22,500.00 $22,500.00 $69,021.77 $69,952.20 $70,901.25 $71,869.27 $72,856.66 $8,615.14 $8,787.45 $8,963.19 $9,142.46 $9,325.31 $6,892.11 $7,029.96 $7,170.56 $7,313.97 $7,460.25 $5,743.43 $5,858.30 $5,975.46 $6,094.97 $6,216.87 $5,743.43 $5,858.30 $5,975.46 $6,094.97 $6,216.87 $18,378.97 $18,746.55 $19,121.48 $19,503.91 $19,893.99 $11,486.86 $11,716.59 $11,950.93 $12,189.94 $12,433.74 $6,892.11 $7,029.96 $7,170.56 $7,313.97 $7,460.25 $6,892.11 $7,029.96 $7,170.56 $7,313.97 $7,460.25 $0.00 $0.00 $0.00 $0.00 $0.00 $13,784.23 $14,059.91 $14,341.11 $14,627.93 $14,920.49 $28,717.14 $29,291.48 $29,877.31 $30,474.86 $31,084.36 $22,973.71 $23,433.19 $23,901.85 $24,379.89 $24,867.49 $17,230.29 $17,574.89 $17,926.39 $18,284.92 $18,650.61 $13,784.23 $14,059.91 $14,341.11 $14,627.93 $14,920.49 $53,988.23 $55,067.99 $56,169.35 $57,292.74 $58,438.59 $189,633.76 $192,976.44 $196,385.97 $199,863.69 $203,410.96
Inventory 2024 TOTAL January Product/ Service Line 1 Cost Per Unit $134,120.90 Cost of Goods Sold $10.25 $12,999.48 $134,120.90 Inventory Item 1 $0.00 $0.00 $134,120.90 Inventory Item 2 $0.00 $0.00 $134,120.90 Inventory Item 3 $0.00 $0.00 $402,362.69 Inventory Expense $0.00 Product/Service Line 2 $301,772.02 Cost of Goods Sold $15.38 $29,248.83 $301,772.02 Inventory Item 1 $0.00 $0.00 $241,417.62 Inventory Item 2 $0.00 $0.00 $270,000.00 Inventory Item 3 $0.00 $0.00 $813,189.63 Inventory Expense $0.00 Product/ Service Line 3 $100,590.67 Cost of Goods Sold $15.38 $9,749.61 $80,472.54 Inventory Item 1 $0.00 $0.00 $67,060.45 Inventory Item 2 $0.00 $0.00 $67,060.45 Inventory Item 3 $0.00 $0.00 $214,593.44 Inventory Expense $0.00 Product/Service Line 4 $134,120.90 Cost of Goods Sold $20.50 $12,999.48 $80,472.54 Inventory Item 1 $0.00 $0.00 $80,472.54 Inventory Item 2 $0.00 $0.00 $0.00 Inventory Item 3 $0.00 $0.00 $160,945.08 Inventory Expense $0.00 Product/Service Line 5 $335,302.24 Cost of Goods Sold $25.63 $32,498.70 $268,241.79 Inventory Item 1 $0.00 $0.00 $201,181.35 Inventory Item 2 $0.00 $0.00 $160,945.08 Inventory Item 3 $0.00 $0.00 $630,368.22 Inventory Expense $0.00 $2,221,459.06 $0.00 Total Monthly Inventory Expense
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
  • Access to all documents
  • Unlimited textbook solutions
  • 24/7 expert homework help
February March April May June $13,259.47 $13,524.66 $13,795.15 $14,071.05 $14,352.47 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $29,833.80 $30,430.48 $31,039.09 $31,659.87 $32,293.07 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $9,944.60 $10,143.49 $10,346.36 $10,553.29 $10,764.36 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $13,259.47 $13,524.66 $13,795.15 $14,071.05 $14,352.47 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $33,148.67 $33,811.64 $34,487.88 $35,177.63 $35,881.19 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
  • Access to all documents
  • Unlimited textbook solutions
  • 24/7 expert homework help
July August September October November $14,639.52 $14,932.31 $15,230.96 $15,535.58 $15,846.29 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $32,938.93 $33,597.71 $34,269.66 $34,955.06 $35,654.16 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $10,979.64 $11,199.24 $11,423.22 $11,651.69 $11,884.72 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $14,639.52 $14,932.31 $15,230.96 $15,535.58 $15,846.29 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $36,598.81 $37,330.79 $38,077.40 $38,838.95 $39,615.73 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
  • Access to all documents
  • Unlimited textbook solutions
  • 24/7 expert homework help
December TOTAL $16,163.22 $174,350.17 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $36,367.24 $392,287.88 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $12,122.41 $130,762.63 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $16,163.22 $174,350.17 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $40,408.04 $435,875.43 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $1,260,736.43 $0.00 $1,260,736.43
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
  • Access to all documents
  • Unlimited textbook solutions
  • 24/7 expert homework help
Marketing Expense 2023 January February March Professional Assistance Marketing Consultants $0.00 $0.00 $0.00 Advertising Agencies $200.00 $200.00 $200.00 SEO Specialist $0.00 $0.00 $0.00 Brochures/Flyers $50.00 $50.00 $50.00 Signs/ Billboards $350.00 $350.00 $350.00 Merchandising Displays $0.00 $0.00 $0.00 Samples $0.00 $0.00 $0.00 Media Advertising Print (newspaper, etc.) $0.00 $0.00 $0.00 Television and Radio $1,300.00 $1,300.00 $1,300.00 Social Media $550.00 $550.00 $550.00 Other $0.00 $0.00 $0.00 Direct Mail $100.00 $100.00 $100.00 Website $50.00 $50.00 $50.00 Trade Shows $600.00 $600.00 $600.00 Memberships $0.00 $0.00 $0.00 Other $300.00 $300.00 $300.00 Grand Total Costs $3,500.00 $3,500.00 $3,500.00
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
  • Access to all documents
  • Unlimited textbook solutions
  • 24/7 expert homework help
April May June July August $0.00 $0.00 $0.00 $0.00 $0.00 $200.00 $200.00 $200.00 $200.00 $200.00 $0.00 $0.00 $0.00 $0.00 $0.00 $50.00 $50.00 $50.00 $50.00 $50.00 $350.00 $350.00 $350.00 $350.00 $350.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $1,300.00 $1,300.00 $1,300.00 $1,300.00 $1,300.00 $550.00 $550.00 $550.00 $550.00 $550.00 $0.00 $0.00 $0.00 $0.00 $0.00 $100.00 $100.00 $100.00 $100.00 $100.00 $50.00 $50.00 $50.00 $50.00 $50.00 $600.00 $600.00 $600.00 $600.00 $600.00 $0.00 $0.00 $0.00 $0.00 $0.00 $300.00 $300.00 $300.00 $300.00 $300.00 $3,500.00 $3,500.00 $3,500.00 $3,500.00 $3,500.00
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
  • Access to all documents
  • Unlimited textbook solutions
  • 24/7 expert homework help
September October November December TOTAL $0.00 $0.00 $0.00 $0.00 $0.00 $200.00 $200.00 $200.00 $200.00 $2,400.00 $0.00 $0.00 $0.00 $0.00 $0.00 $50.00 $50.00 $50.00 $50.00 $600.00 $350.00 $350.00 $350.00 $350.00 $4,200.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $1,300.00 $1,300.00 $1,300.00 $1,300.00 $15,600.00 $550.00 $550.00 $550.00 $550.00 $6,600.00 $0.00 $0.00 $0.00 $0.00 $0.00 $100.00 $100.00 $100.00 $100.00 $1,200.00 $50.00 $50.00 $50.00 $50.00 $600.00 $600.00 $600.00 $600.00 $600.00 $7,200.00 $0.00 $0.00 $0.00 $0.00 $0.00 $300.00 $300.00 $300.00 $300.00 $3,600.00 $3,500.00 $3,500.00 $3,500.00 $3,500.00 $42,000.00
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
  • Access to all documents
  • Unlimited textbook solutions
  • 24/7 expert homework help
2024 January February March April May $0.00 $0.00 $0.00 $0.00 $0.00 $200.00 $200.00 $200.00 $200.00 $200.00 $0.00 $0.00 $0.00 $0.00 $0.00 $50.00 $50.00 $50.00 $50.00 $50.00 $350.00 $350.00 $350.00 $350.00 $350.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $1,300.00 $1,300.00 $1,300.00 $1,300.00 $1,300.00 $550.00 $550.00 $550.00 $550.00 $550.00 $0.00 $0.00 $0.00 $0.00 $0.00 $100.00 $100.00 $100.00 $100.00 $100.00 $50.00 $50.00 $50.00 $50.00 $50.00 $600.00 $600.00 $600.00 $600.00 $600.00 $0.00 $0.00 $0.00 $0.00 $0.00 $300.00 $300.00 $300.00 $300.00 $300.00 $3,500.00 $3,500.00 $3,500.00 $3,500.00 $3,500.00
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
  • Access to all documents
  • Unlimited textbook solutions
  • 24/7 expert homework help
June July August September October $0.00 $0.00 $0.00 $0.00 $0.00 $200.00 $200.00 $200.00 $200.00 $200.00 $0.00 $0.00 $0.00 $0.00 $0.00 $50.00 $50.00 $50.00 $50.00 $50.00 $350.00 $350.00 $350.00 $350.00 $350.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $1,300.00 $1,300.00 $1,300.00 $1,300.00 $1,300.00 $550.00 $550.00 $550.00 $550.00 $550.00 $0.00 $0.00 $0.00 $0.00 $0.00 $100.00 $100.00 $100.00 $100.00 $100.00 $50.00 $50.00 $50.00 $50.00 $50.00 $600.00 $600.00 $600.00 $600.00 $600.00 $0.00 $0.00 $0.00 $0.00 $0.00 $300.00 $300.00 $300.00 $300.00 $300.00 $3,500.00 $3,500.00 $3,500.00 $3,500.00 $3,500.00
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
  • Access to all documents
  • Unlimited textbook solutions
  • 24/7 expert homework help
November December TOTAL $0.00 $0.00 $0.00 $200.00 $200.00 $2,400.00 $0.00 $0.00 $0.00 $50.00 $50.00 $600.00 $350.00 $350.00 $4,200.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $1,300.00 $1,300.00 $15,600.00 $550.00 $550.00 $6,600.00 $0.00 $0.00 $0.00 $100.00 $100.00 $1,200.00 $50.00 $50.00 $600.00 $600.00 $600.00 $7,200.00 $0.00 $0.00 $0.00 $300.00 $300.00 $3,600.00 $3,500.00 $3,500.00 $42,000.00
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
  • Access to all documents
  • Unlimited textbook solutions
  • 24/7 expert homework help
Staff Expenses 2023 January February March Management # Salaried Employees 1 1 1 Average Salary per employee $4,250.00 $4,250.00 $4,250.00 Benefits $416.67 $416.67 $416.67 Payroll Taxes $637.50 $637.50 $637.50 Total Costs $5,304.17 $5,304.17 $5,304.17 Adminstrative/Support # Salaried Employees 2 2 2 Average Salary per employee $4,600.00 $4,600.00 $4,600.00 Benefits $833.33 $833.33 $833.33 Payroll Taxes $1,380.00 $1,380.00 $1,380.00 Total Costs $11,413.33 $11,413.33 $11,413.33 Sales/Marketing # Salaried Employees 5 5 5 Average Salary per employee $2,100.00 $2,100.00 $2,100.00 Benefits $2,083.33 $2,083.33 $2,083.33 Payroll Taxes $1,575.00 $1,575.00 $1,575.00 Total Costs $14,158.33 $14,158.33 $14,158.33 Operations/Production # Salaried Employees 1 1 1 Average Salary per employee $2,200.00 $2,200.00 $2,200.00 Benefits $416.67 $416.67 $416.67 Payroll Taxes $330.00 $330.00 $330.00 Total Costs $2,946.67 $2,946.67 $2,946.67 Other # Salaried Employees 1 1 1 Average Salary per employee $2,000.00 $2,000.00 $2,000.00 Benefits $416.67 $416.67 $416.67 Payroll Taxes $300.00 $300.00 $300.00 Total Costs $2,716.67 $2,716.67 $2,716.67 Part-Time Employees # Part-Time Employees 0 0 0 Average hours per employee 0 0 0 Average Hourly Rate $0.00 $0.00 $0.00 Wages per hourly employee $0.00 $0.00 $0.00 Wages $0.00 $0.00 $0.00 Benefits $0.00 $0.00 $0.00
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
  • Access to all documents
  • Unlimited textbook solutions
  • 24/7 expert homework help
Payroll Taxes $0.00 $0.00 $0.00 Total Costs $0.00 $0.00 $0.00 Total # Full Time Employees 10 10 10 # Part-Time Employees 0 0 0 Salary/Wages $28,150.00 $28,150.00 $28,150.00 Benefits $4,166.67 $4,166.67 $4,166.67 Payroll Taxes $4,222.50 $4,222.50 $4,222.50 Total Costs $36,549.17 $36,549.17 $36,549.17
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
  • Access to all documents
  • Unlimited textbook solutions
  • 24/7 expert homework help
April May June July August 1 1 1 1 1 $4,250.00 $4,250.00 $4,250.00 $4,250.00 $4,250.00 $416.67 $416.67 $416.67 $416.67 $416.67 $637.50 $637.50 $637.50 $637.50 $637.50 $5,304.17 $5,304.17 $5,304.17 $5,304.17 $5,304.17 2 2 2 2 2 $4,600.00 $4,600.00 $4,600.00 $4,600.00 $4,600.00 $833.33 $833.33 $833.33 $833.33 $833.33 $1,380.00 $1,380.00 $1,380.00 $1,380.00 $1,380.00 $11,413.33 $11,413.33 $11,413.33 $11,413.33 $11,413.33 5 5 5 5 5 $2,100.00 $2,100.00 $2,100.00 $2,100.00 $2,100.00 $2,083.33 $2,083.33 $0.00 $2,083.33 $2,083.33 $1,575.00 $1,575.00 $1,575.00 $1,575.00 $1,575.00 $14,158.33 $14,158.33 $12,075.00 $14,158.33 $14,158.33 1 1 1 1 1 $2,200.00 $2,200.00 $2,200.00 $2,200.00 $2,200.00 $416.67 $416.67 $416.67 $416.67 $416.67 $330.00 $330.00 $330.00 $330.00 $330.00 $2,946.67 $2,946.67 $2,946.67 $2,946.67 $2,946.67 1 1 1 1 1 $2,000.00 $2,000.00 $2,000.00 $2,000.00 $2,000.00 $416.67 $416.67 $416.67 $416.67 $416.67 $300.00 $300.00 $300.00 $300.00 $300.00 $2,716.67 $2,716.67 $2,716.67 $2,716.67 $2,716.67 0 0 0 0 0 0 0 0 0 0 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
  • Access to all documents
  • Unlimited textbook solutions
  • 24/7 expert homework help
$0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 10 10 10 10 10 0 0 0 0 0 $28,150.00 $28,150.00 $28,150.00 $28,150.00 $28,150.00 $4,166.67 $4,166.67 $2,083.33 $4,166.67 $4,166.67 $4,222.50 $4,222.50 $4,222.50 $4,222.50 $4,222.50 $36,549.17 $36,549.17 $34,465.83 $36,549.17 $36,549.17
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
  • Access to all documents
  • Unlimited textbook solutions
  • 24/7 expert homework help
September October November December TOTAL 1 1 1 1 $4,250.00 $4,250.00 $4,250.00 $4,250.00 $51,000.00 $416.67 $416.67 $416.67 $416.67 $5,000.00 $637.50 $637.50 $637.50 $637.50 $7,650.00 $5,304.17 $5,304.17 $5,304.17 $5,304.17 $63,650.00 2 2 2 2 $4,600.00 $4,600.00 $4,600.00 $4,600.00 $55,200.00 $833.33 $833.33 $833.33 $833.33 $10,000.00 $1,380.00 $1,380.00 $1,380.00 $1,380.00 $16,560.00 $11,413.33 $11,413.33 $11,413.33 $11,413.33 $81,760.00 5 5 5 5 $2,100.00 $2,100.00 $2,100.00 $2,100.00 $25,200.00 $2,083.33 $2,083.33 $2,083.33 $2,083.33 $22,916.67 $1,575.00 $1,575.00 $1,575.00 $1,575.00 $18,900.00 $14,158.33 $14,158.33 $14,158.33 $14,158.33 $67,016.67 1 1 1 1 $2,200.00 $2,200.00 $2,200.00 $2,200.00 $26,400.00 $416.67 $416.67 $416.67 $416.67 $5,000.00 $330.00 $330.00 $330.00 $330.00 $3,960.00 $2,946.67 $2,946.67 $2,946.67 $2,946.67 $35,360.00 1 1 1 1 $2,000.00 $2,000.00 $2,000.00 $2,000.00 $24,000.00 $416.67 $416.67 $416.67 $416.67 $5,000.00 $300.00 $300.00 $300.00 $300.00 $3,600.00 $2,716.67 $2,716.67 $2,716.67 $2,716.67 $32,600.00 0 0 0 0 0 0 0 0 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
  • Access to all documents
  • Unlimited textbook solutions
  • 24/7 expert homework help
$0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 10 10 10 10 0 0 0 0 $28,150.00 $28,150.00 $28,150.00 $28,150.00 $337,800.00 $4,166.67 $4,166.67 $4,166.67 $4,166.67 $47,916.67 $4,222.50 $4,222.50 $4,222.50 $4,222.50 $50,670.00 $36,549.17 $36,549.17 $36,549.17 $36,549.17 $436,386.67
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
  • Access to all documents
  • Unlimited textbook solutions
  • 24/7 expert homework help
2024 January February March April May 1 1 1 1 1 $4,398.75 $4,398.75 $4,398.75 $4,398.75 $4,398.75 $431.25 $431.25 $431.25 $431.25 $431.25 $659.81 $659.81 $659.81 $659.81 $659.81 $5,489.81 $5,489.81 $5,489.81 $5,489.81 $5,489.81 2 2 2 2 2 $4,761.00 $4,761.00 $4,761.00 $4,761.00 $4,761.00 $862.50 $862.50 $862.50 $862.50 $862.50 $1,428.30 $1,428.30 $1,428.30 $1,428.30 $1,428.30 $11,812.80 $11,812.80 $11,812.80 $11,812.80 $11,812.80 5 5 5 5 5 $2,173.50 $2,173.50 $2,173.50 $2,173.50 $2,173.50 $2,156.25 $2,156.25 $2,156.25 $2,156.25 $2,156.25 $1,630.13 $1,630.13 $1,630.13 $1,630.13 $1,630.13 $14,653.88 $14,653.88 $14,653.88 $14,653.88 $14,653.88 1 1 1 1 1 $2,277.00 $2,277.00 $2,277.00 $2,277.00 $2,277.00 $431.25 $431.25 $431.25 $431.25 $431.25 $341.55 $341.55 $341.55 $341.55 $341.55 $3,049.80 $3,049.80 $3,049.80 $3,049.80 $3,049.80 1 1 1 1 1 $2,070.00 $2,070.00 $2,070.00 $2,070.00 $2,070.00 $431.25 $431.25 $431.25 $431.25 $431.25 $310.50 $310.50 $310.50 $310.50 $310.50 $2,811.75 $2,811.75 $2,811.75 $2,811.75 $2,811.75 0 0 0 0 0 0 0 0 0 0 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
  • Access to all documents
  • Unlimited textbook solutions
  • 24/7 expert homework help
$0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 10 10 10 10 10 0 0 0 0 0 $29,135.25 $29,135.25 $29,135.25 $29,135.25 $29,135.25 $4,312.50 $4,312.50 $4,312.50 $4,312.50 $4,312.50 $4,370.29 $4,370.29 $4,370.29 $4,370.29 $4,370.29 $37,828.04 $37,828.04 $37,828.04 $37,828.04 $37,828.04
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
  • Access to all documents
  • Unlimited textbook solutions
  • 24/7 expert homework help
June July August September October 1 1 1 1 1 $4,398.75 $4,398.75 $4,398.75 $4,398.75 $4,398.75 $431.25 $431.25 $431.25 $431.25 $431.25 $659.81 $659.81 $659.81 $659.81 $659.81 $5,489.81 $5,489.81 $5,489.81 $5,489.81 $5,489.81 2 2 2 2 2 $4,761.00 $4,761.00 $4,761.00 $4,761.00 $4,761.00 $862.50 $862.50 $862.50 $862.50 $862.50 $1,428.30 $1,428.30 $1,428.30 $1,428.30 $1,428.30 $11,812.80 $11,812.80 $11,812.80 $11,812.80 $11,812.80 5 5 5 5 5 $2,173.50 $2,173.50 $2,173.50 $2,173.50 $2,173.50 $2,156.25 $2,156.25 $2,156.25 $2,156.25 $2,156.25 $1,630.13 $1,630.13 $1,630.13 $1,630.13 $1,630.13 $14,653.88 $14,653.88 $14,653.88 $14,653.88 $14,653.88 1 1 1 1 1 $2,277.00 $2,277.00 $2,277.00 $2,277.00 $2,277.00 $431.25 $431.25 $431.25 $431.25 $431.25 $341.55 $341.55 $341.55 $341.55 $341.55 $3,049.80 $3,049.80 $3,049.80 $3,049.80 $3,049.80 1 1 1 1 1 $2,070.00 $2,070.00 $2,070.00 $2,070.00 $2,070.00 $431.25 $431.25 $431.25 $431.25 $431.25 $310.50 $310.50 $310.50 $310.50 $310.50 $2,811.75 $2,811.75 $2,811.75 $2,811.75 $2,811.75 0 0 0 0 0 0 0 0 0 0 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
  • Access to all documents
  • Unlimited textbook solutions
  • 24/7 expert homework help
$0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 10 10 10 10 10 0 0 0 0 0 $29,135.25 $29,135.25 $29,135.25 $29,135.25 $29,135.25 $4,312.50 $4,312.50 $4,312.50 $4,312.50 $4,312.50 $4,370.29 $4,370.29 $4,370.29 $4,370.29 $4,370.29 $37,828.04 $37,828.04 $37,828.04 $37,828.04 $37,828.04
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
  • Access to all documents
  • Unlimited textbook solutions
  • 24/7 expert homework help
November December TOTAL 1 1 $4,398.75 $4,398.75 $52,785.00 $431.25 $431.25 $5,175.00 $659.81 $659.81 $7,917.75 $5,489.81 $5,489.81 $65,877.75 2 2 $4,761.00 $4,761.00 $57,132.00 $862.50 $862.50 $10,350.00 $1,428.30 $1,428.30 $17,139.60 $11,812.80 $11,812.80 $84,621.60 5 5 $2,173.50 $2,173.50 $26,082.00 $2,156.25 $2,156.25 $25,875.00 $1,630.13 $1,630.13 $19,561.50 $14,653.88 $14,653.88 $71,518.50 1 1 $2,277.00 $2,277.00 $27,324.00 $431.25 $431.25 $5,175.00 $341.55 $341.55 $4,098.60 $3,049.80 $3,049.80 $36,597.60 1 1 $2,070.00 $2,070.00 $24,840.00 $431.25 $431.25 $5,175.00 $310.50 $310.50 $3,726.00 $2,811.75 $2,811.75 $33,741.00 0 0 0 0 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
  • Access to all documents
  • Unlimited textbook solutions
  • 24/7 expert homework help
$0.00 $0.00 $0.00 $0.00 $0.00 $0.00 10 10 0 0 $29,135.25 $29,135.25 $349,623.00 $4,312.50 $4,312.50 $51,750.00 $4,370.29 $4,370.29 $52,443.45 $37,828.04 $37,828.04 $453,816.45
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
  • Access to all documents
  • Unlimited textbook solutions
  • 24/7 expert homework help
Capital Expenditures Item Cost Purchase Date Facilities Month Year Trash Removal $40.00 January 2023 1 Electricity Cost $650.00 January 2023 1 Gas Cost $65.00 January 2023 1 Water Cost $300.00 January 2023 1 Rented Facility $3,642.00 January 2023 1 Equipment Benches & Hook $900.00 January 2023 1 Rack & Shelves $70.00 January 2023 1 Coach & Table $300.00 January 2023 1 Cars $100,000.00 January 2023 1 $0.00 January 2023 1 $0.00 January 2023 1 $0.00 January 2023 1 $0.00 January 2023 1 Computer Hardware/Software Computer $350.00 January 2023 1 CCTV Camera $400.00 January 2023 1 Item Name $0.00 January 2023 1 Item Name $0.00 January 2023 1 Item Name $0.00 January 2023 1 Item Name $0.00 January 2023 1 Item Name $0.00 January 2023 1 Telecommunications TELEPHONE $300.00 January 2023 1 Counterfeit $100.00 January 2023 1 Barcode Reader $200.00 January 2023 1 Money Code Reader $200.00 January 2023 1 Receipt Reader $200.00 January 2023 1 Land $0.00 January 2023 Does $0.00 January 2023 Does Years of Service
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
  • Access to all documents
  • Unlimited textbook solutions
  • 24/7 expert homework help
Salvage Value $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 s not depreciate s not depreciate
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
  • Access to all documents
  • Unlimited textbook solutions
  • 24/7 expert homework help
You may use a Depreciation calculator to determine your numbers to enter in the Financial Statemen
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
  • Access to all documents
  • Unlimited textbook solutions
  • 24/7 expert homework help
Income Statement 2023 January February March Income Gross Sales $150,000.00 $153,000.00 $156,060.00 (Cost of Goods) $75,000.00 $76,500.00 $78,030.00 Gross Profit $75,000.00 $76,500.00 $78,030.00 Expenses - General and Administrative Salaries/Wages $28,150.00 $28,150.00 $28,150.00 Benefits $4,166.67 $4,166.67 $4,166.67 Payroll Taxes $4,222.50 $4,222.50 $4,222.50 Marketing and Advertising $3,500.00 $3,500.00 $3,500.00 Rent $0.00 $0.00 $0.00 Equipmental rental $0.00 $0.00 $0.00 Maintenance $0.00 $0.00 $0.00 Depreciation $0.00 $0.00 $0.00 Insurance $0.00 $0.00 $0.00 Telephone Service $0.00 $0.00 $0.00 Utilities $0.00 $0.00 $0.00 Office Supplies and Shipping $0.00 $0.00 $0.00 Travel and Entertainment $0.00 $0.00 $0.00 Interest on loans $0.00 $0.00 $0.00 Other $0.00 $0.00 $0.00 Other $0.00 $0.00 $0.00 Total Expenses $40,039.17 $40,039.17 $40,039.17 Net income before taxes and interest $34,960.83 $36,460.83 $37,990.83 Provision for taxes on income $5,244.13 $5,469.13 $5,698.63 Net Profit $29,716.71 $30,991.71 $32,292.21
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
  • Access to all documents
  • Unlimited textbook solutions
  • 24/7 expert homework help
April May June July August $159,181.20 $162,364.82 $165,612.12 $168,924.36 $172,302.85 $79,590.60 $81,182.41 $82,806.06 $84,462.18 $86,151.43 $79,590.60 $81,182.41 $82,806.06 $84,462.18 $86,151.43 $28,150.00 $28,150.00 $28,150.00 $28,150.00 $28,150.00 $4,166.67 $4,166.67 $2,083.33 $4,166.67 $4,166.67 $4,222.50 $4,222.50 $4,222.50 $4,222.50 $4,222.50 $3,500.00 $3,500.00 $3,500.00 $3,500.00 $3,500.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $40,039.17 $40,039.17 $37,955.83 $40,039.17 $40,039.17 $39,551.43 $41,143.25 $44,850.23 $44,423.01 $46,112.26 $5,932.72 $6,171.49 $6,727.53 $6,663.45 $6,916.84 $33,618.72 $34,971.76 $38,122.69 $37,759.56 $39,195.42
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
  • Access to all documents
  • Unlimited textbook solutions
  • 24/7 expert homework help
September October November December TOTAL $175,748.91 $179,263.89 $182,849.16 $186,506.15 $2,011,813.46 $87,874.45 $89,631.94 $91,424.58 $93,253.07 $1,005,906.73 $87,874.45 $89,631.94 $91,424.58 $93,253.07 $1,005,906.73 $28,150.00 $28,150.00 $28,150.00 $28,150.00 $337,800.00 $4,166.67 $4,166.67 $4,166.67 $4,166.67 $47,916.67 $4,222.50 $4,222.50 $4,222.50 $4,222.50 $50,670.00 $3,500.00 $3,500.00 $3,500.00 $3,500.00 $42,000.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $40,039.17 $40,039.17 $40,039.17 $40,039.17 $478,386.67 $47,835.29 $49,592.78 $51,385.41 $53,213.91 $527,520.06 $7,175.29 $7,438.92 $7,707.81 $7,982.09 $79,128.01 $40,659.99 $42,153.86 $43,677.60 $45,231.82 $448,392.05
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
  • Access to all documents
  • Unlimited textbook solutions
  • 24/7 expert homework help
2024 January February March April May $194,992.18 $198,892.02 $202,869.86 $206,927.26 $211,065.80 $97,496.09 $99,446.01 $101,434.93 $103,463.63 $105,532.90 $97,496.09 $99,446.01 $101,434.93 $103,463.63 $105,532.90 $29,135.25 $29,135.25 $29,135.25 $29,135.25 $29,135.25 $4,312.50 $4,312.50 $4,312.50 $4,312.50 $4,312.50 $4,370.29 $4,370.29 $4,370.29 $4,370.29 $4,370.29 $3,500.00 $3,500.00 $3,500.00 $3,500.00 $3,500.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $41,318.04 $41,318.04 $41,318.04 $41,318.04 $41,318.04 $56,178.05 $58,127.97 $60,116.89 $62,145.59 $64,214.86 $8,426.71 $8,719.20 $9,017.53 $9,321.84 $9,632.23 $47,751.34 $49,408.78 $51,099.36 $52,823.75 $54,582.63
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
  • Access to all documents
  • Unlimited textbook solutions
  • 24/7 expert homework help
June July August September October $215,287.12 $219,592.86 $223,984.72 $228,464.41 $233,033.70 $107,643.56 $109,796.43 $111,992.36 $114,232.21 $116,516.85 $107,643.56 $109,796.43 $111,992.36 $114,232.21 $116,516.85 $29,135.25 $29,135.25 $29,135.25 $29,135.25 $29,135.25 $4,312.50 $4,312.50 $4,312.50 $4,312.50 $4,312.50 $4,370.29 $4,370.29 $4,370.29 $4,370.29 $4,370.29 $3,500.00 $3,500.00 $3,500.00 $3,500.00 $3,500.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $41,318.04 $41,318.04 $41,318.04 $41,318.04 $41,318.04 $66,325.52 $68,478.39 $70,674.32 $72,914.17 $75,198.81 $9,948.83 $10,271.76 $10,601.15 $10,937.13 $11,279.82 $56,376.69 $58,206.63 $60,073.17 $61,977.04 $63,918.99
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
  • Access to all documents
  • Unlimited textbook solutions
  • 24/7 expert homework help
November December TOTAL $237,694.37 $242,448.26 $2,615,252.56 $118,847.19 $121,224.13 $1,307,626.28 $118,847.19 $121,224.13 $1,307,626.28 $29,135.25 $29,135.25 $349,623.00 $4,312.50 $4,312.50 $51,750.00 $4,370.29 $4,370.29 $52,443.45 $3,500.00 $3,500.00 $42,000.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $41,318.04 $41,318.04 $495,816.45 $77,529.15 $79,906.09 $811,809.83 $11,629.37 $11,985.91 $121,771.47 $65,899.78 $67,920.18 $690,038.36
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
  • Access to all documents
  • Unlimited textbook solutions
  • 24/7 expert homework help
Cash Flow 2023 January February March Income from Sales Cash Sales $150,000.00 $153,000.00 $156,060.00 Income from Financing Equity Capital Investments $0.00 $0.00 $0.00 Other Cash Receipts $0.00 $0.00 $0.00 TOTAL CASH RECEIPTS $150,000.00 $153,000.00 $156,060.00 Cash Disbursements Inventory $168,000.00 $170,910.00 $173,878.20 Operating Expenses $40,039.17 $40,039.17 $40,039.17 Capital Expenditures $0.00 $0.00 $0.00 Loan Payments $0.00 $0.00 $0.00 Income Tax Payments $0.00 $0.00 $0.00 TOTAL CASH DISBURSEMENTS $208,039.17 $210,949.17 $213,917.37 Net Cash Flow -$58,039.17 -$57,949.17 -$57,857.37 Opening Cash Balance $5,000.00 -$53,039.17 -$110,988.33 Cash Receipts $150,000.00 $153,000.00 $156,060.00 Cash Disbursements $208,039.17 $210,949.17 $213,917.37 ENDING CASH BALANCE -$53,039.17 -$110,988.33 -$168,845.70
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
  • Access to all documents
  • Unlimited textbook solutions
  • 24/7 expert homework help
April May June July August $159,181.20 $162,364.82 $165,612.12 $168,924.36 $172,302.85 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $159,181.20 $162,364.82 $165,612.12 $168,924.36 $172,302.85 $176,905.76 $179,993.88 $183,143.76 $186,356.63 $189,633.76 $40,039.17 $40,039.17 $37,955.83 $40,039.17 $40,039.17 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $216,944.93 $220,033.05 $221,099.59 $226,395.80 $229,672.93 -$57,763.73 -$57,668.22 -$55,487.47 -$57,471.44 -$57,370.08 -$168,845.70 -$226,609.43 -$284,277.65 -$339,765.12 -$397,236.56 $159,181.20 $162,364.82 $165,612.12 $168,924.36 $172,302.85 $216,944.93 $220,033.05 $221,099.59 $226,395.80 $229,672.93 -$226,609.43 -$284,277.65 -$339,765.12 -$397,236.56 -$454,606.64
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
  • Access to all documents
  • Unlimited textbook solutions
  • 24/7 expert homework help
September October November December TOTAL $175,748.91 $179,263.89 $182,849.16 $186,506.15 $2,011,813.46 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $175,748.91 $179,263.89 $182,849.16 $186,506.15 $2,011,813.46 $192,976.44 $196,385.97 $199,863.69 $203,410.96 $2,221,459.06 $40,039.17 $40,039.17 $40,039.17 $40,039.17 $478,386.67 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $233,015.61 $236,425.14 $239,902.85 $243,450.13 $2,699,845.72 -$57,266.70 -$57,161.25 -$57,053.69 -$56,943.98 -$688,032.26 -$454,606.64 -$511,873.34 -$569,034.59 -$626,088.28 $175,748.91 $179,263.89 $182,849.16 $186,506.15 $233,015.61 $236,425.14 $239,902.85 $243,450.13 -$511,873.34 -$569,034.59 -$626,088.28 -$683,032.26 -$683,032.26
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
  • Access to all documents
  • Unlimited textbook solutions
  • 24/7 expert homework help
2024 January February March April May $194,992.18 $198,892.02 $202,869.86 $206,927.26 $211,065.80 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $194,992.18 $198,892.02 $202,869.86 $206,927.26 $211,065.80 $0.00 $0.00 $0.00 $0.00 $0.00 $41,318.04 $41,318.04 $41,318.04 $41,318.04 $41,318.04 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $41,318.04 $41,318.04 $41,318.04 $41,318.04 $41,318.04 $153,674.14 $157,573.98 $161,551.82 $165,609.22 $169,747.76 -$683,032.26 -$529,358.12 -$371,784.14 -$210,232.32 -$44,623.10 $194,992.18 $198,892.02 $202,869.86 $206,927.26 $211,065.80 $41,318.04 $41,318.04 $41,318.04 $41,318.04 $41,318.04 -$529,358.12 -$371,784.14 -$210,232.32 -$44,623.10 $125,124.66
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
  • Access to all documents
  • Unlimited textbook solutions
  • 24/7 expert homework help
June July August September October $215,287.12 $219,592.86 $223,984.72 $228,464.41 $233,033.70 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $215,287.12 $219,592.86 $223,984.72 $228,464.41 $233,033.70 $0.00 $0.00 $0.00 $0.00 $0.00 $41,318.04 $41,318.04 $41,318.04 $41,318.04 $41,318.04 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $41,318.04 $41,318.04 $41,318.04 $41,318.04 $41,318.04 $173,969.08 $178,274.82 $182,666.68 $187,146.37 $191,715.66 $125,124.66 $299,093.74 $477,368.57 $660,035.25 $847,181.62 $215,287.12 $219,592.86 $223,984.72 $228,464.41 $233,033.70 $41,318.04 $41,318.04 $41,318.04 $41,318.04 $41,318.04 $299,093.74 $477,368.57 $660,035.25 $847,181.62 $1,038,897.29
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
  • Access to all documents
  • Unlimited textbook solutions
  • 24/7 expert homework help
November December TOTAL $237,694.37 $242,448.26 $2,615,252.56 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $237,694.37 $242,448.26 $2,615,252.56 $0.00 $0.00 $0.00 $41,318.04 $41,318.04 $495,816.45 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $41,318.04 $41,318.04 $495,816.45 $196,376.34 $201,130.22 $2,119,436.11 $1,038,897.29 $1,235,273.62 $237,694.37 $242,448.26 $41,318.04 $41,318.04 $1,235,273.62 $1,436,403.85 $1,436,403.85
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
  • Access to all documents
  • Unlimited textbook solutions
  • 24/7 expert homework help
Balance Sheet Company Name 2023 ASSETS Current Assets Cash -$683,032.26 Accounts Receivable $0.00 Inventory $2,221,459.06 Other Current Assets $0.00 TOTAL CURRENT ASSETS $1,538,426.79 Fixed Assets Land $0.00 Facilities $0.00 Equipment $0.00 Computers & Telecommunications $0.00 (Less Accumalated Depreciation) $0.00 Total Fixed Assets $0.00 Other Assets $0.00 TOTAL ASSETS $1,538,426.79 LIABILITIES Current Liabilities Short-term Loan (less than 12 months) $0.00 Other Current Liabilities $0.00 TOTAL CURRENT LIABILITIES $0.00 Long-Term Liabilities Long-Term Loans (Over 12 months) $0.00 Other Long-Term Liabilities $0.00 TOTAL LONG-TERM LIABILITIES $0.00 TOTAL LIABILITIES $0.00 Shareholders Equity Paid-In Capital $0.00 Retained Earnings $0.00 Total Shareholders Equity $0.00 TOTAL LIABILITIES AND SHAREHOLDER EQUITY $0.00
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
  • Access to all documents
  • Unlimited textbook solutions
  • 24/7 expert homework help
Balance Sheet Company Name 2024 ASSETS Current Assets Cash $1,436,403.85 Accounts Receivable $0.00 Inventory $1,260,736.43 Other Current Assets $0.00 TOTAL CURRENT ASSETS $2,697,140.28 Fixed Assets Land $0.00 Facilities $0.00 Equipment $0.00 Computers & Telecommunications $0.00 (Less Accumalated Depreciation) $0.00 Total Fixed Assets $0.00 Other Assets $0.00 TOTAL ASSETS LIABILITIES Current Liabilities Short-term Notes Payable (less than 12 months) $0.00 Iother Current Liabilities $0.00 TOTAL CURRENT LIABILITIES $0.00 Long-Term Liabilities Long-Term Notes Payable (Over 12 months) $0.00 Other Long-Term Liabilities $0.00 TOTAL LONG-TERM LIABILITIES $0.00 TOTAL LIABILITIES Shareholders Equity Paid-In Capital $0.00 Retained Earnings $0.00 Total Shareholders Equity $0.00 TOTAL LIABILITIES AND SHAREHOLDER EQUITY
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
  • Access to all documents
  • Unlimited textbook solutions
  • 24/7 expert homework help
$2,697,140.28 $0.00 $0.00
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
  • Access to all documents
  • Unlimited textbook solutions
  • 24/7 expert homework help
Breakeven Estimates Year 1 2023 January $20,019.58 February $20,019.58 March $20,019.58 April $20,019.58 May $20,019.58 June $18,977.92 July $20,019.58 August $20,019.58 September $20,019.58 October $20,019.58 November $20,019.58 December $20,019.58 Monthly Average $19,932.78 Year 2 2024 January $20,659.02 February $20,659.02 March $20,659.02 April $20,659.02 May $20,659.02 June $20,659.02 July $20,659.02 August $20,659.02 September $20,659.02 October $20,659.02 November $20,659.02 December $20,659.02 Monthly Average $20,659.02 Amount of sales needed each month to breakeven.
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
  • Access to all documents
  • Unlimited textbook solutions
  • 24/7 expert homework help

Related Documents

CH3.docx
notes.docx
BSBHRM613 Self-.docx
Untitled document.edited - 2023-11-18T104150.617.docx
NORCO and ACF.docx
attachment_1 - 2023-07-10T152920.596.docx
Case 18.3 SUMMARY.docx
Organization Development Exams.final.docx
QAWA1.docx
chapter 11 weekly 11.docx
Entrepreneurial Thinking.pdf
Discusion Week 5.edited.docx
Recommended textbooks for you
Text book image
Understanding Business
Management
ISBN:9781259929434
Author:William Nickels
Publisher:McGraw-Hill Education
Text book image
Management (14th Edition)
Management
ISBN:9780134527604
Author:Stephen P. Robbins, Mary A. Coulter
Publisher:PEARSON
Text book image
Spreadsheet Modeling & Decision Analysis: A Pract...
Management
ISBN:9781305947412
Author:Cliff Ragsdale
Publisher:Cengage Learning
Text book image
Management Information Systems: Managing The Digi...
Management
ISBN:9780135191798
Author:Kenneth C. Laudon, Jane P. Laudon
Publisher:PEARSON
Text book image
Business Essentials (12th Edition) (What's New in...
Management
ISBN:9780134728391
Author:Ronald J. Ebert, Ricky W. Griffin
Publisher:PEARSON
Text book image
Fundamentals of Management (10th Edition)
Management
ISBN:9780134237473
Author:Stephen P. Robbins, Mary A. Coulter, David A. De Cenzo
Publisher:PEARSON
SEE MORE TEXTBOOKS
Recommended textbooks for you
Text book image
Understanding Business
Management
ISBN:9781259929434
Author:William Nickels
Publisher:McGraw-Hill Education
Text book image
Management (14th Edition)
Management
ISBN:9780134527604
Author:Stephen P. Robbins, Mary A. Coulter
Publisher:PEARSON
Text book image
Spreadsheet Modeling & Decision Analysis: A Pract...
Management
ISBN:9781305947412
Author:Cliff Ragsdale
Publisher:Cengage Learning
Text book image
Management Information Systems: Managing The Digi...
Management
ISBN:9780135191798
Author:Kenneth C. Laudon, Jane P. Laudon
Publisher:PEARSON
Text book image
Business Essentials (12th Edition) (What's New in...
Management
ISBN:9780134728391
Author:Ronald J. Ebert, Ricky W. Griffin
Publisher:PEARSON
Text book image
Fundamentals of Management (10th Edition)
Management
ISBN:9780134237473
Author:Stephen P. Robbins, Mary A. Coulter, David A. De Cenzo
Publisher:PEARSON
SEE MORE TEXTBOOKS