YOU HAVE TO MAKE YOUR OWN ASSUMPTIONS. THERE IS NOT INFORMATION PROVIDED.

Think about a product that you would like to develop and sell. Your group will be making a budget presentation to the group in hopes of receiving budget approval for your ideas. Information items to communicate at this meeting are as follows:

1) Quarterly Sales Budget for a Year

2) Quarterly Production Budget for a Year

3) Quarterly Cost of Goods Sold Budget for a Year

4) Quarterly General and Administrative (other non-manufacturing) Expense Budget for a Year

5) Quarterly Capital Expenditure Budget for a Year (assume that you are starting the business without assets)

6) Quarterly Cash Budgets for a Year

7) Budgeted Income Statement for the Entire Year (not for each quarter)

8) Budget Balance Sheet at the end of the Year (assuming A=L+E are all 0 to start the Year)

9) Budgeted Statement of Cash Flows

ANY NUMBERS CAN BE USED. PLEASE PROVIDE STEPS ON HOW TO DO IT IN EXCEL