Ikechukwu Ugbo | Freelancer Portfolio Item #64965

Zozi Signature Interior Design 15 Name of Company Business Type Duration Please note that only coloured cells can be edited Uncoloured cells have been locked to avoid computation errors Steps Line Items Model Guidelines Guidelines 1 Data Page & Guidelines Go to the Data Page & Guidelines sheet to input the name of the Company, Business Type and the Duration of the Forecast. 2 Input Worksheet Proceed to the assumption sheet and input the following assumptions below 3 General section Start from the general section and input the effective tax rate, 4 Growth rate section This section is for inflation inputs and growth rate of some revenue and costs metrics over the duration of the forecast. Key in the relevant growth rate for each revenue and cost line. 5 Startup Costs This section is for all initial costs needed to get the business to operational status. It also includes periodic additions of capital cost over the duration of the forecast. Go this section and key in all the relevant start up costs 6 Financing Structure This refers to the capital structure of the businessin relation to debt and equity. Key in the debt ratio in the cell shaded grey 7 Revenue This section includes metrics that show how the revenue of the business is derived and how it grows over the period. Base volume refers to the initial quantity of goods available at startup while base price refers to the initial price. The base price and volumes will increase in line with the growth rate specified in in the growth section. All you need to do is to key in the base price and volume. 8 Operating Costs Direct costs refers to the cost of sales for the business. The Other operating costs represents the base costs which will grow in line with the growth rate specified in the growth rate section of the assumptions sheet. 9 Debt Financing Assumptions This sections illustrates how the business intends to service its debt. Multiple debt facilities can be projected in the rows provided. 10 Tenor Tenor is the length of the debt facility. 11 Moratorium Moratium refers to the initial period where the lender gives the business a specified period as relief in which no debt service is made. 12 Repayment Period This refers to the number of years in which the facility will be repaid. It excludes the moratorium period. 13 Drawdown This is the amount of debt being serviced in the current period. 14 Loan Amortisation Schedule This shows the loan book of the business indicating the beginning and outstanding (closing) balances for each period. This section requires no input and will auto-compute as the preceding sections are inputed. 15 Equity This shows the equity scenario of the business, also showing the opening and closing balances. It shows new equity injections every period, if any and the dividend due to the business owner per period. 16 Cashflow Worksheet This worksheet shows the business' flow of cash, also showing the cash position at several stages. This sheet requires no input as it will auto-compute. 17 Profit & Loss Sheet 18 Balance Sheet This summarizes the revenues , costs and expenses incurred during a specific period, usually a year. This states the assets, liabilities, and capital of a business for two periods; past and current. Zozi Signature Cashflow Waterfall Interior Design 15 Years Financial Model Year 1 General Reporting currency Effective Tax rate Forecast Period % NGN 30% Years 15 Year(s) Growth Rate General Inflation % 0 % % % % % % % % % % % % % % % % % % % 0 0 0%- Specfic Inflation rate Price growth rate Volume growth rate Rent Salaries and Wages Electricity Cost Fuelling Costs Inusrance costs Cost Item 1 Cost Item 2 Cost Item 3 Cost Item 4 Cost Item 5 Cost Item 6 Cost Item 7 Cost Item 8 Cost Item 9 Cost Item 10 Cost Item 11 Cost Item 12 Start up Costs Start-up Costs Rent Renovations Furnitures and Fittings Delivery Truck Internet Installation Cable Installation Raw Materials Generator Salaries and Wages Office Supplies Telephone Bills Utilities Advertising Travel Maintenance Startup Cost Item 12 Startup Cost Item 13 Startup Cost Item 14 Startup Cost Item 15 Startup Cost Item 16 Total cost N'- Startup Cost Item 17 Startup Cost Item 18 Startup Cost Item 19 Startup Cost Item 20 Startup Cost Item 21 Startup Cost Item 22 Startup Cost Item 23 Startup Cost Item 24 Startup Cost Item 25 Startup Cost Item 26 Startup Cost Item 27 Startup Cost Item 28 Startup Cost Item 29 Startup Cost Item 30 Startup Cost Item 31 Total Start up Capex Periodic Additional Capex - N'000 N'000 3 0 Financing Structure Equity Debt % % % 0.5 0.5 1 Base Volume Base Price Units N - Periodic Volume Periodic Price Units N 0 0 % 0 Revenue Operating Costs Direct costs Office Costs Rent Salaries and Wages Electricity Cost Fuelling Costs Inusrance costs Cost Item 1 Cost Item 2 Cost Item 3 Cost Item 4 Cost Item 5 Cost Item 6 Cost Item 7 Cost Item 8 Cost Item 9 Cost Item 10 Cost Item 11 Cost Item 12 Total Debt Financing assumptions N'000 N'000 N'000 N'000 N'000 N'000 N'000 N'000 N'000 N'000 N'000 N'000 N'000 N'000 N'000 N'000 N'000 N'000 - Tenor - Facility 1 Tenor - Facility 2 Tenor - Facility 3 Tenor - Facility 4 Tenor - Facility 5 Tenor - Facility 6 Tenor - Facility 7 Tenor - Facility 8 Tenor - Facility 9 Tenor - Facility 10 Tenor - Facility 11 Tenor - Facility 12 Tenor - Facility 13 Tenor - Facility 14 Tenor - Facility 15 Years Years Years Years Years Years Years Years Years Years Years Years Years Years Years - Moratorium - Facility 1 Moratorium - Facility 2 Moratorium - Facility 3 Moratorium - Facility 4 Moratorium - Facility 5 Moratorium - Facility 6 Moratorium - Facility 7 Moratorium - Facility 8 Moratorium - Facility 9 Moratorium - Facility 10 Moratorium - Facility 11 Moratorium - Facility 12 Moratorium - Facility 13 Moratorium - Facility 14 Moratorium - Facility 15 Years Years Years Years Years Years Years Years Years Years Years Years Years Years Years - Repayment Period - Facility 1 Repayment Period - Facility 2 Repayment Period - Facility 3 Repayment Period - Facility 4 Repayment Period - Facility 5 Repayment Period - Facility 6 Repayment Period - Facility 7 Repayment Period - Facility 8 Repayment Period - Facility 9 Repayment Period - Facility 10 Repayment Period - Facility 11 Repayment Period - Facility 12 Repayment Period - Facility 13 Repayment Period - Facility 14 Repayment Period - Facility 15 Years Years Years Years Years Years Years Years Years Years Years Years Years Years Years - Dradown - Facility 1 Dradown - Facility 2 Dradown - Facility 3 Dradown - Facility 4 Dradown - Facility 5 Dradown - Facility 6 Dradown - Facility 7 Dradown - Facility 8 Dradown - Facility 9 Dradown - Facility 10 Dradown - Facility 11 Dradown - Facility 12 Dradown - Facility 13 Dradown - Facility 14 N'000 N'000 N'000 N'000 N'000 N'000 N'000 N'000 N'000 N'000 N'000 N'000 N'000 N'000 - Year 1 Year 2 Year 3 Year 4 Year 5 Year 6 Year 7 Year 8 Year 9 Year 10 Year 11 Year 12 Year 13 Year 14 - Dradown - Facility 15 Interest rate N'000 0 % 0 Year 15 0 1 Loan Amortisation Schedule Beginning Loan Balance Drawdown Repayment - Facility 1 Repayment - Facility 2 Repayment - Facility 3 Repayment - Facility 4 Repayment - Facility 5 Repayment - Facility 6 Repayment - Facility 7 Repayment - Facility 8 Repayment - Facility 9 Repayment - Facility 10 Repayment - Facility 11 Repayment - Facility 12 Repayment - Facility 13 Repayment - Facility 14 Repayment - Facility 15 Outstanding Loan Balance N'000 N'000 N'000 N'000 N'000 N'000 N'000 N'000 N'000 N'000 N'000 N'000 N'000 N'000 N'000 N'000 N'000 N'000 0 1 #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? Interest Payment N'000 0 Equity Injection N'000 0 Opening Balance Equity Injection Closing Balance N'000 N'000 N'000 0 1 1 % 0 Equity Dividends >>> End of Worksheet Year 2 Year 3 Year 4 Year 5 Year 6 Year 7 Year 8 Year 9 Year 10 0.1 0.1 0.1 0.1 0.1 0.1 0.1 0.1 0.1 - - - - - - - - - 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 - - - - - - - - - 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 #NAME? 0 #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? 0 #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? 0 #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? 0 #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? 0 #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? 0 #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? 0 #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? 0 #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? 0 #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? 0 0 0 0 0 0 0 0 0 1 0 1 1 0 1 1 0 1 1 0 1 1 0 1 1 0 1 1 0 1 1 0 1 1 0 1 0 0 0 0 0 0 0 0 0 Year 11 Year 12 Year 13 Year 14 Year 15 0.1 0.1 0.1 0.1 0.1 - - - - - 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 - - - - - 0 0 0 0 0 0 0 0 0 0 #NAME? 0 #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? 0 #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? 0 #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? 0 #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? 0 #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? 0 0 0 0 0 1 0 1 1 0 1 1 0 1 1 0 1 1 0 1 0 0 0 0 0 Zozi Signature Cashflow Waterfall Interior Design 15 Years Financial Model Year 1 Year 2 Cash received from customers Direct Costs Rent Salaries and Wages Electricity Cost Fuelling Costs Inusrance costs Cost Item 1 Cost Item 2 Cost Item 3 Cost Item 4 Cost Item 5 Cost Item 6 Cost Item 7 Cost Item 8 Cost Item 9 Cost Item 10 Cost Item 11 Cost Item 12 Taxation Cash flow from operations N 000 N 000 N 000 N 000 N 000 N 000 N 000 N 000 N 000 N 000 N 000 N 000 N 000 N 000 N 000 N 000 N 000 N 000 N 000 N 000 N 000 - #NAME? 0 - #NAME? 0 Capital Expenditure Cash flow available for loan repayment N 000 N 000 3 3 0 0 Equity Injection Loan Taken Loan interest Loan repayment Cash flow available for sole proprietor N 000 N 000 N 000 1 1 0 #NAME? #NAME? 0 0 #NAME? #NAME? #NAME? Dividend Net cash balance N 000 N 000 #NAME? #NAME? #NAME? #NAME? Cash balalance b/f Net cash balance Cash bal c/f N 000 N 000 N 000 0 #NAME? #NAME? #NAME? #NAME? #NAME? >>> End of Worksheet Year 3 Year 4 Year 5 Year 6 Year 7 Year 8 - #NAME? 0 - #NAME? 0 - #NAME? 0 - #NAME? 0 - #NAME? 0 - #NAME? 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 #NAME? #NAME? #NAME? 0 0 #NAME? #NAME? #NAME? 0 0 #NAME? #NAME? #NAME? 0 0 #NAME? #NAME? #NAME? 0 0 #NAME? #NAME? #NAME? 0 0 #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? Year 9 Year 10 Year 11 Year 12 Year 13 Year 14 - #NAME? 0 - #NAME? 0 - #NAME? 0 - #NAME? 0 - #NAME? 0 - #NAME? 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 #NAME? #NAME? #NAME? 0 0 #NAME? #NAME? #NAME? 0 0 #NAME? #NAME? #NAME? 0 0 #NAME? #NAME? #NAME? 0 0 #NAME? #NAME? #NAME? 0 0 #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? Year 15 - #NAME? 0 0 0 0 0 #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? Zozi Signature Profit and Loss Statement Interior Design PROFIT AND LOSS STATEMENT 2016 JAN FEB MAR APR MAY $4,100 $4,100 $4,100 $4,100 $4,100 0 (250) 0 0 (234) Sales Discounts (Reduction) (410) (410) (410) (410) (410) Income from goods delivery 200 200 190 209 209 After sales services and Repairs 250 0 263 0 0 Net Sales 4,140 3,640 4,143 3,899 3,665 Cost of Goods Sold 1,300 1,300 1,300 1,300 1,300 #NAME? #NAME? #NAME? #NAME? #NAME? JAN FEB MAR APR MAY $517 $517 $517 $517 $517 193 193 193 193 193 2,267 0 0 0 0 50 51 52 53 54 267 67 68 68 69 Telephone 68 68 68 68 68 Insurance 125 125 125 125 125 Travel 100 105 110 116 122 Maintenance 100 105 110 116 122 Advertising 100 105 110 116 122 Total Operation Expenses $3,787 $1,336 $1,353 $1,372 $1,391 Income From Operations #NAME? #NAME? #NAME? #NAME? #NAME? Interest Income (Expense) (100) (105) (110) (116) (122) #NAME? #NAME? #NAME? #NAME? #NAME? 0 #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? Sales Sales Returns (Reduction) Gross Profit Operation Expenses Salaries & Wages Depreciation Rent Office Supplies Utilities Income Before Income Taxes Income Tax Expense Net Income NET INCOME #NAME? ND LOSS STATEMENT JUN JUL AUG SEP OCT NOV DEC YTD $4,100 $4,305 $4,520 $4,746 $4,984 $5,233 $5,494 $53,882 0 0 (300) (410) (431) (452) (475) (498) (523) (549) (5,388) 219 230 250 253 279 307 337 2,884 0 300 0 0 0 0 0 813 3,909 4,405 4,018 4,525 4,764 5,016 5,282 51,407 1,300 1,365 1,433 1,505 1,580 1,659 1,742 17,085 #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? JUN JUL AUG SEP OCT NOV DEC YTD $517 $543 $570 $598 $628 $660 $693 $6,794 193 203 213 223 235 246 259 2,536 0 0 0 0 0 0 0 2,267 55 56 57 59 60 61 62 671 70 70 71 72 73 73 74 1,042 68 68 68 68 68 68 68 816 125 125 125 125 125 125 125 1,500 128 134 141 148 155 163 171 1,592 128 134 144 144 144 144 144 1,534 128 134 141 148 155 163 171 1,592 $1,411 $1,467 $1,530 $1,585 $1,643 $1,703 $1,767 $20,344 #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? (128) (134) #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? (784) (814) $56,576 ($823) ($5,658) $3,028 $853 $53,977 $17,939 $62,234 ($906) ($6,223) $3,331 $938 $59,375 $19,733 #NAME? #NAME? $0 $0 $7,134 $2,663 $2,380 $704 $1,094 $857 $1,575 $1,671 $1,611 $1,671 $7,848 $2,930 $2,618 $775 $1,203 $942 $1,733 $1,838 $1,772 $1,838 $21,361 $23,497 #NAME? ($855) #NAME? #NAME? #NAME? ($940) #NAME? #NAME? #NAME? #NAME? Zozi Signature Profit and Loss Statement Interior Design Balance Sheet FY-[Year 1] FY-[YEAR 2] YEAR 3 Current Assets Cash 51,407 Err:509 Investments Inventories Err:509 5,000 5,000 5000 671 704 775.0 Accounts receivable 0 0 Err:509 Pre-paid expenses 0 0 Err:509 Other 0 0 Err:509 Total Err:508 Err:508 Err:508 Fixed Assets Property and equipment 200 160 190 Leasehold improvements 180 150 170 1,500 1,500 1,500 (2,536) (2,663) -2,930 Equity and other investments Less accumulated depreciation (Negative Value) Total -1070 Err:508 Err:508 Err:508 Err:508 Err:508 Err:508 Err:508 Err:508 Other Assets Charity Total Total Assets Current Liabilities Accounts payable Accrued wages Accrued compensation 19,733 6,794 7,134 7,848 5,077 Unearned revenue Err:509 5,331 0 Err:509 Other Long-term Liabilities 17,939 0 Err:509 Income taxes payable Total 17,085 13,565 Err:508 Err:509 14,078 Err:508 5,- Err:508 Mortgage payable Total 0 Err:508 0 0 Err:508 Err:508 Owner Equity Investment capital 5,000 5,000 5000 Accumulated retained earnings 8,901 9,346 10,280 Total Err:508 Err:508 Err:508 Total Liabilities & Stockholder Equity Err:508 Err:508 Err:508 Model Guidelines S/N 1 Item Reporting currency 2 Effective Tax rate - Forecast Period General Inflation Price growth rate Volume growth rate Rent Salaries and Wages Electricity Cost Fuelling Costs Inusrance costs Start-up Costs Renovations 15 Furnitures and Fittings - Delivery Truck Internet Installation Cable Installation Start up Capex Periodic Additional Capex Financing Structure Equity Debt 24 Revenue - Base Volume Base Price Periodic Volume Periodic Price Operating Costs Direct costs Debt Financing assumptions Tenor - Facility 33 Moratorium - Facility - Repayment Period - Facility Drawdown - Facility Interest rate Loan Amortisation Schedule Beginning Loan Balance Drawdown Interest Payment Equity Injection Dividends Cash received from customers Taxation Cash flow from operations Capital Expenditure Equity Injection Loan Taken Cash flow available for sole proprietor Net cash balance Cash balalance b/f 57 Net cash balance 58 Cash bal c/f Model Guidelines Definition This refers to the currency is which the business model is financed The effective tax rate for a corporation is the average rate at which its pre-tax profits are taxedThe effective tax rate for a corporation is the average rate at which its pre-tax profits are taxed This refers to the period over which the business model is forecasted This refers to the sustained increase in price level over time This is the rate at which the businesses' sale price will grow over time This is the rate at which the volume of sales will grow over time This is the property rent to be paid by the business annually Salary & wages paid out by the business to its Staff This is the cost of electricity incurred by the business This is the cost of fuel incurred by the business Insurance costs incurred by the business for all its assets Initial costs required to start the business Periodic costs incurred on the businesses' assets This refer to movable furniture, fixtures, or other equipment that have no permanent connection to the structure of a building or utilities Cost of procuring a delivery truck for the business Cost for installing internet for the business Cost for installing cable tv for the business Start-up capital expenditure (same as start up costs) Same as renovation This refers to the means through which financed is sourced for the business such as the share of debt and equity This is the value of ownership interest in the business This is the value of funds borrowed to finance the business Sales income from business operations. It is either paid in cash by customers or credited to the custormer's account as a receivable This is the volume of inventory that the bussiness has at the beginning This is the price per product based on which the business commences operations This is the inventory stock in subsequent periods calculated using the volume growth rate and base volume This is the inventory stock in subsequent periods calculated using the price growth rate and base price This refer to the recurring costs of running the business e.g salaries and wages This is cost that is directly attributable to the sales made by the business This are the assumptions around which money is borrowed by the business This is the period of time for which the business borrows money This refers the number of initial years in the tenor during which the business doesn’t repay any part of the loan taken. Interest over this period is accrued and paid in subsequent years This is the number of years in the tenor during which the loan taken is repaid This is the part of the principal borrowed that is paid back periodically This is the interest charged on the loan periodically This is a schedule showing the amount of principal and interest paid on the loan during each period This is the amount of loan yet unpaid during each period This is the part of the principal borrowed that is paid back periodically This is the interest paid on the loan periodically This is new equity capital put into the business by the owners This is the periodic payment to equity holders in the business after the debtors have been paid This is the portion of revenue that is paid in cash. This is the amount of tax paid by the business periodically This is the total cash flow from the core operations of the business Capital expenditure is an amount spent to acquire or improve a long-term asset such as equipment or buildings This is new equity capital put into the business by the owners This is the part of the principal borrowed that is paid back periodically This is cash available to the owner of the business from which he can make withdrawals (dividends) Amount left after withdrawals have been made by the owner This is the retained earnings (profits not paid as dividends to the owner) of the business from previous periods Amount left after withdrawals have been made by the owner in the current period This is the retained earnings of the business from previous periods plus amount left after withdrawals have been made by the owner in the current period