I just need something made up and the numbers to work together. I need an income and balance sheet for a fake startup small business. Income Statement and balance sheet needed for project PLEASE! If i could import it directly to excel that would be amazing. Anything will be great

Task: You will create and plan for a fictitious company.

Task: Determine the steps needed to start a business and the related start-up costs. You will research various websites such as comptroller.texas.gov and IRS.gov (see below) to determine the steps that are needed to start a business

1. Create an Income Statement in Excel for the first year of business for your company. Be sure to include any and all revenue and expense categories that would be related to the type of business you have chosen. For example, if I am opening an accounting firm, I might have bookkeeping revenue, tax preparation revenue, consulting revenue, etc. For expenses, I might have office rent (if I do not own my building), salaries expense, supplies expense, etc. If you borrowed money to start your company, be sure to include interest expense on the loan.

You MUST COMPLETE THIS IN EXCEL. You must use formulas for totals rather than hard-keying in the numbers. For example, total revenues would be entered as a sum formula adding up all of the types of revenue. Net Income or Net Loss would be entered as total revenues cell total expenses cell.

1. Create a Balance Sheet in Excel for the first year of business for your company. Put it on the second page of the Excel worksheet you created for the income statement in #1. Be sure to include any and all asset, liabilities and stockholder categories that would be related to the type of business you have chosen. For example, if you told me in part 2 of your project that you would issue stock to finance the business, you need to have that amount of stockholders equity listed, if you said you would borrow money from a bank, you need to have that listed under liabilities. Your assets section should report the assets you listed in Part 2 of the project that you would need to start, as well as any cash you have accumulated after the first year of business, inventory, accounts receivable, etc. Since you are a new company, you do not have any beginning retained earnings so your ending retained earnings balance on your balance sheet should be equal to your net income minus any dividends you paid out (you do not have to pay out dividends.)