Purchase Solution

Income Statement and a Balance Sheet

Not what you're looking for?

Ask Custom Question

Hello What I need is a simple Income statement and a balance sheet in excel for a business plan.
Please make up the 2 financial sheets balanced and ready for me to view and understand. You may add numbers and make up fictional debits and credits, etc as you go. Just as long as it balances. The purpose is for me to be able to start up a business in assembling and selling furniture. NOTE: It must be done showing a 3 year projection in Excel.
Here is the following of what I have to start the business: (May cahnge as you please for rapidness and balancing)
1. $95,000 to start with
2. 2 small trucks
3. overhead rent is $500 per month
4. Electric is $125 per month
5. Already have tool and equipment at hand valued at 5,000
6. 2 employees (owners) salaries at 2,500 a month
7. 2 part time employees to be called in at $6.00 an hour averaging 20 hours a week
8. Bank loan is at $60,000 which is part of the initial start-up asset (if it can be considered an asset?)
9. Furniture purchase (To sell) is $6,000 1st year, $7,000 second year, $8,000 3rd
year.
10. picked up a 3 year contract account with chase bank of the Valley to assemble furniture at a contract of $20,000 the first year and with an additional 5 % increase each year after.
11. Picked up a 3 year contract account with Holiday in to asseble and repair furniture for $16,000 for the first year and a 5% increase for the coming years.
12. picked up an account with Montgomery Ward to assemble their furiniture for displays fo 3 years at $25,000 plus a 5% increase in the coming years.
13. projected furniture sales to individual customers are at $12,000, year 1, $13,000-year2, and $14,000 year 3.
14. road services and individual public customer furniture assembly is expected to range from year 1-$10,000, Year 2-$11,000, and Year 3- $12,000.
15. Other Expenses - Fuel, auto repairs, etc...Please make up a figure>
16. Liabilities and owners equity? -- Please use your imagination.

Remember, you can make any figures up as you need to. Like I said, I just need a simple 3 year balance sheet and income statement on EXCEL on this business I am making up as a furniture assembler/ small amount of furniture sales. You can change any of the figures I submitted as you wish. They are not written in stone. Just keep it simple so I can study it. Thanks for your help and I will be sure to reply with the appropriate OTA evaluation.

Purchase this Solution

Solution Summary

I have modeled the excel sheet using data section and calculation section separately. In calculations cell references are used so that you can see the formulas and calculation steps. This also enables you change the figures in data section (colored cells) and see the its effect in income statement and balance sheet. It means you can simulate the effect of changes in data section.

Solution Preview

Hello

Please see the file attached here. It contains all the details, assumptionsd, formulae. I have modeled this excel ...

Purchase this Solution


Free BrainMass Quizzes
Cost Concepts: Analyzing Costs in Managerial Accounting

This quiz gives students the opportunity to assess their knowledge of cost concepts used in managerial accounting such as opportunity costs, marginal costs, relevant costs and the benefits and relationships that derive from them.

Marketing Research and Forecasting

The following quiz will assess your ability to identify steps in the marketing research process. Understanding this information will provide fundamental knowledge related to marketing research.

Social Media: Pinterest

This quiz introduces basic concepts of Pinterest social media

Basic Social Media Concepts

The quiz will test your knowledge on basic social media concepts.

Lean your Process

This quiz will help you understand the basic concepts of Lean.