Capstone Assignment Group Pro Forma Financial Statement Project
In your groups, using the Financial Statement Projection Spreadsheet used for BA499, develop a full set of projected financial statements for a hypothetical company.
To complete this project provide the following:
1. A description of your hypothetical company. This description must make it clear to me what the company does; the product or service it will be providing; the target market to be served and what portion of the target market the company plans to serve (this must be realistic and specify the number of people), where it will be located, the number of employees it will have, how the company anticipates financing the business, and any other information necessary for me to understand the company.
2. A detailed list of assumptions used to project the financial statements. These assumptions must include how sales were computed based on the target market you will serve.
3. The excel file that includes the group's projected financial statements. This will show 3 years of projections with the first year by month.
4. A short description (300-600 words for each group member) written by each member of the group describing what they learned from the project. These should be written separately, not as a group, although I want you to include them in one WORD file. Be sure to show each members name at the beginning of their section.
5. The project will be submitted the same way you have submitted each of the previous Bb assignments into the Bb submission folder. This is a challenging project, but will substantially help prepare you for BA 499. The time to start is upon you. Your financial statements will not be perfect, but you must be clear about all your assumptions.
When you are making a wild guess make it clear in your assumptions that you are doing that. You can be far more accurate than you think. Be reasonable, talk to other business people, and use ratios for your industry to help you with your projections. Your sales projections should be based on your target market. How many people will you sell to, how many times, and what will be the average amount of a transaction. Demonstrate how you have the capacity to sell to that number of people.
Attachment:- ba_385_timeline_for_capstone_assignment_0.docx