please help very very very urgent!!!! kindly solve all the parts.
My Cash L 1021 MC We Stian Mar Apr MEN ep TO Toch w . 15 11 74C 0 ha 21 Tot es sold AR w Page 1 with w whic 34 Hack La Doening US Monthly Cashflow section Loan Amorturation Scheule PPE Amortization Schedule Proforma IS Closing BS To start Nosmell Sani Inc., you invest $75,000 cash and your personal computer valued at $4,000 (as at Dec 31, 2020). The estimated life of the computer is 5 years Projected events during the upcoming year: The 5,000 sq ft manufacturing location you have leased has a cost is $15 per square feet triple net. Triple net cost are $10 per square feet. You plan to purchase the manufacturing equipment required at a New Years Day sales on January 1, 2021. Unfortunately, it cannot be installed February 1, 2021. The cost of the equipment is $20,000. Nosmell Sani Inc will pay $5,000 in cash and secure financing for the remaining $15,000. The loan terms are 8% for a 10-year loan. The estimated life of the manufacturing equipment is 10 years. Hint: Use the PMT Function you learned in BUAD 128, Computer Applications to calculate the monthly repoyment. It is found under Formulas in Excel You plan to start manufacturing the hand sanitizer on the day the equipment is installed, February 1, 2021 with the hopes that the first batch will be ready to ship mid-month, Nosmell Sani Inc. will have: an annual advertising budget of $30,000 an annual administration wages are $40,000 dual Assignments Financial Assigninent . . variable wages of $2 per bottle of hand sanitizer produced including benefits) direct material costs of 3 bottle of hand sanitizer produced annual business insurance is $2,000 Insurance policy is from an 2001- Dec 2021 . annual utilities costs are $10,000 Note the costs tend to increase in the winter month monthly internet and phone cast are $200 monthly vehicle et $400 per month ticipate anal fuel con 56000 Initial website Development conti 52.00 dary 11 2071 estimated ide of years. Subsequent monthly web non fees are $100 00 B Date 6 ASSETS 7 Current Assets 8 cash 9 $ 75.000 10 11 12 Total Current Assets 13 14 Property Plant & Equipment 15 16 17 Page 1 21 18 13 20 Total Property Plant & Equipment 22 Total Assets 23 24 LIABILITIES & EQUITY 25 Liabilities 26 27 28 23 30 Total Liabilities 31 Equity 32 33 34 35 Total Equity 36 Total Liabilities and Equity 37 38 Opening BS Enter Accessibility: Investigate 10" Mostly cloudy Monthly Cash Flow Projection Loan 1 Company Name 2 Proforma Income Statement 3 For the year ended Decmeber 31, 2021 ON 0009 $ $ Page 1 4 5 6 Revenues 7 Sales Revenue 8 Other Revenue Total Revenue 10 11 Cost of Goods Sold 12 Gross Profit 13 14 Expenses 15 Advertising Depreciation expense 17 Employee Wages and Benefits 18 Insurance 19 Interest Expense 20 Lease Payment 21 Communication (WIFI, Telephone) 22 Utilities 23 Web Hosting 24 Vehicle Expenses 25 Taxes 26 Total Expenses Net Income 28 29 16 27 Prepared By: Company Name Proforma Balance Sheet Date 9 10 6 ASSETS 7 Current Assets 8 Cash Acoounts Receivable Inventory 11 12 Total Current Assets 13 14 Property Plant & Equipment 15 Equipment 16 Less accumulated deprecitation (equipment) 17 Computer 18 Less accumulated deprecitation loomputer) 19 Website 20 Less accumulated deprecitation (website) 21 Total Property Plant & Equipment 22 Total Assets 23 24 LIABILITIES & EQUITY 25 Liabilities 26 Accounts Payable 27 Equipment Loans Balance 28 Line of Credit Balance 29 Total Liabilities 30 Equity 31 Increase in Owners Equity 32 Owners Equity 33 Owners Draw 34 35 Total Liabilities and Equity 36 Polonaust 1 Total Equity 37 December 31, 2020 To start Nosmell Sani Inc, you invest $75,000 cash and your personal computer valued at $4,000 (as at Dec 31, 2020). The estimated life of the computer is 5 years. . Projected events during the upcoming year: The 5,000 sq ft manufacturing location you have leased has a cost is $15 per square feet triple net. Triple net cost are $10 per square feet. You plan to purchase the manufacturing equipment required at a New Years Day sales on January 1, 2021. Unfortunately, it cannot be installed February 1, 2021. The cost of the equipment is $20,000. Nosmell Sani Inc. will pay $5,000 in cash and secure financing for the remaining $15,000. The loan terms are 8% for a 10-year loan. The estimated life of the manufacturing equipment is 10 years. Hint: Use the PMT Function you learned in BUAD 128, Computer Applications to calculate the monthly repayment. It is found under Formulas in Excel You plan to start manufacturing the hand sanitizer on the day the equipment is installed, February 1, 2021 with the hopes that the first batch will be ready to ship mid-month. Nosmell Sani Inc. will have: an annual advertising budget of $30,000 an annual administration wages are $40,000 Individual Assignment #5 - Financial Assignment . . variable wages of $2 per bottle of hand sanitizer produced including benefits) direct material costs of $3 bottle of hand Sanitizer produced annual business Insurance is $2,000. Insurance policy is from Jan 2021 Dec 2021 annual utilities costs are $10,000. Note these costs tend to increase in the winter months monthly internet and phone costare 5200 monthly vehiclelease is 5400 per month, anticipated annual fuel cost is $4.000 Initial website development cost is $2,000 paid January 1, 2021 with an estimated life of years. Subsequent monthly web hosting fees are $100 . st Mosty Gallow Project 2012 December 31, 2015 terial con Wouten The IM AM My 2 AL Sep Der Catal Locs Cash 15.000 15 15 13 15 3 15 who ine w D ES 5 ruh Jetonlof God Operating Activities Meeting Wapes and then Page 1 1 C W Two Veloupe Lancial Der with Chow et achteflow 5 15.000 15.000 dalaman dan ERRORRECORER LR Inan Amortization Schele PPE Amortization Schedule Proforma IS Closing BS Onamin C My Cash L 1021 MC We Stian Mar Apr MEN ep TO Toch w . 15 11 74C 0 ha 21 Tot es sold AR w Page 1 with w whic 34 Hack La Doening US Monthly Cashflow section Loan Amorturation Scheule PPE Amortization Schedule Proforma IS Closing BS To start Nosmell Sani Inc., you invest $75,000 cash and your personal computer valued at $4,000 (as at Dec 31, 2020). The estimated life of the computer is 5 years Projected events during the upcoming year: The 5,000 sq ft manufacturing location you have leased has a cost is $15 per square feet triple net. Triple net cost are $10 per square feet. You plan to purchase the manufacturing equipment required at a New Years Day sales on January 1, 2021. Unfortunately, it cannot be installed February 1, 2021. The cost of the equipment is $20,000. Nosmell Sani Inc will pay $5,000 in cash and secure financing for the remaining $15,000. The loan terms are 8% for a 10-year loan. The estimated life of the manufacturing equipment is 10 years. Hint: Use the PMT Function you learned in BUAD 128, Computer Applications to calculate the monthly repoyment. It is found under Formulas in Excel You plan to start manufacturing the hand sanitizer on the day the equipment is installed, February 1, 2021 with the hopes that the first batch will be ready to ship mid-month, Nosmell Sani Inc. will have: an annual advertising budget of $30,000 an annual administration wages are $40,000 dual Assignments Financial Assigninent . . variable wages of $2 per bottle of hand sanitizer produced including benefits) direct material costs of 3 bottle of hand sanitizer produced annual business insurance is $2,000 Insurance policy is from an 2001- Dec 2021 . annual utilities costs are $10,000 Note the costs tend to increase in the winter month monthly internet and phone cast are $200 monthly vehicle et $400 per month ticipate anal fuel con 56000 Initial website Development conti 52.00 dary 11 2071 estimated ide of years. Subsequent monthly web non fees are $100 00 B Date 6 ASSETS 7 Current Assets 8 cash 9 $ 75.000 10 11 12 Total Current Assets 13 14 Property Plant & Equipment 15 16 17 Page 1 21 18 13 20 Total Property Plant & Equipment 22 Total Assets 23 24 LIABILITIES & EQUITY 25 Liabilities 26 27 28 23 30 Total Liabilities 31 Equity 32 33 34 35 Total Equity 36 Total Liabilities and Equity 37 38 Opening BS Enter Accessibility: Investigate 10" Mostly cloudy Monthly Cash Flow Projection Loan 1 Company Name 2 Proforma Income Statement 3 For the year ended Decmeber 31, 2021 ON 0009 $ $ Page 1 4 5 6 Revenues 7 Sales Revenue 8 Other Revenue Total Revenue 10 11 Cost of Goods Sold 12 Gross Profit 13 14 Expenses 15 Advertising Depreciation expense 17 Employee Wages and Benefits 18 Insurance 19 Interest Expense 20 Lease Payment 21 Communication (WIFI, Telephone) 22 Utilities 23 Web Hosting 24 Vehicle Expenses 25 Taxes 26 Total Expenses Net Income 28 29 16 27 Prepared By: Company Name Proforma Balance Sheet Date 9 10 6 ASSETS 7 Current Assets 8 Cash Acoounts Receivable Inventory 11 12 Total Current Assets 13 14 Property Plant & Equipment 15 Equipment 16 Less accumulated deprecitation (equipment) 17 Computer 18 Less accumulated deprecitation loomputer) 19 Website 20 Less accumulated deprecitation (website) 21 Total Property Plant & Equipment 22 Total Assets 23 24 LIABILITIES & EQUITY 25 Liabilities 26 Accounts Payable 27 Equipment Loans Balance 28 Line of Credit Balance 29 Total Liabilities 30 Equity 31 Increase in Owners Equity 32 Owners Equity 33 Owners Draw 34 35 Total Liabilities and Equity 36 Polonaust 1 Total Equity 37 December 31, 2020 To start Nosmell Sani Inc, you invest $75,000 cash and your personal computer valued at $4,000 (as at Dec 31, 2020). The estimated life of the computer is 5 years. . Projected events during the upcoming year: The 5,000 sq ft manufacturing location you have leased has a cost is $15 per square feet triple net. Triple net cost are $10 per square feet. You plan to purchase the manufacturing equipment required at a New Years Day sales on January 1, 2021. Unfortunately, it cannot be installed February 1, 2021. The cost of the equipment is $20,000. Nosmell Sani Inc. will pay $5,000 in cash and secure financing for the remaining $15,000. The loan terms are 8% for a 10-year loan. The estimated life of the manufacturing equipment is 10 years. Hint: Use the PMT Function you learned in BUAD 128, Computer Applications to calculate the monthly repayment. It is found under Formulas in Excel You plan to start manufacturing the hand sanitizer on the day the equipment is installed, February 1, 2021 with the hopes that the first batch will be ready to ship mid-month. Nosmell Sani Inc. will have: an annual advertising budget of $30,000 an annual administration wages are $40,000 Individual Assignment #5 - Financial Assignment . . variable wages of $2 per bottle of hand sanitizer produced including benefits) direct material costs of $3 bottle of hand Sanitizer produced annual business Insurance is $2,000. Insurance policy is from Jan 2021 Dec 2021 annual utilities costs are $10,000. Note these costs tend to increase in the winter months monthly internet and phone costare 5200 monthly vehiclelease is 5400 per month, anticipated annual fuel cost is $4.000 Initial website development cost is $2,000 paid January 1, 2021 with an estimated life of years. Subsequent monthly web hosting fees are $100 . st Mosty Gallow Project 2012 December 31, 2015 terial con Wouten The IM AM My 2 AL Sep Der Catal Locs Cash 15.000 15 15 13 15 3 15 who ine w D ES 5 ruh Jetonlof God Operating Activities Meeting Wapes and then Page 1 1 C W Two Veloupe Lancial Der with Chow et achteflow 5 15.000 15.000 dalaman dan ERRORRECORER LR Inan Amortization Schele PPE Amortization Schedule Proforma IS Closing BS Onamin C
