solved Chose a publicly traded company and answer a series of

Chose a publicly traded company and answer a series of questions on that company each week. The questions given will be related to the topics covered in classes of that week. 
Question Set 1:
1) What is your company’s principal business activity?
2) Who is the CFO? What is his/her accounting background? Give as much detail as you see necessary.
3) Is your company managing any ethical issues presently? If so, how do their actions affect their financial performance going forward?
Question Set 2:
1) Take the income statement of your company and transfer this to excel.
2) What is the largest expense/cost item on your income statement? Using your annual report (notes to the financial statements) explain what is causing this expense. Can you think of some strategies to reduce this?
Question Set 3:
1) Identify the costs/expenses as either variable of fixed. For the variable cost per unit, you will have to find or estimate the total products sold during the fiscal year.
2) Write the cost function for your company. 
Part 2 
This assignment was locked May 29 at 8:59pm.
Building on the corrections suggested (if any) from Part I, Part II of the term assignment continues with the introduction of the Master Budget. Students are required to first transfer the balance sheet and income statement to excel in order to use the data to make a quarterly budget. Following the examples from the master budgets worked on in class, students are required to make the necessary budget schedules to build a Cash Budget and Capital Budget.
Question Set 1:
1) Transfer your company’s balance sheet to an excel sheet like you did with your income statement. Also include a screenshot of the original balance sheet and income statement in the worksheet on excel.
2) Track your company’s stock price this week. Record the amount the stock price increased or decreased each day, totaling five days. I will provide an example of this during class.
Question Set 2:
1) What is the strategic plan of your company? Are there any specific long range plans? (Form -10k or Annual Report)
2) With your sales forecast, you now have to assemble the data to make your master budget. Below is a list of the data points you will have to find using your company’s most recent income statement, balance sheet, and possibly cash flow statement:
– Divide your cost of goods sold by total sales to get the cost of goods sold percentage
– Add together the fixed expsenses form your income statement and divide the total by 12 to get the monthly total.
– Add togetherbthe variable expenses (excluding COGS) from the income statement and divide the total by the sales revenue total to get your variable expense percentage.
– Divide the depreciation expense total by 12 to get the monthly depreciation.
– Divide the Income tax expense by Earnings before income taxes to find the income tax rate.
– Search for a rate of interest from the annual report of the company. Use the rate you find when you make a capital budget.
Additional Information Needed to Make Master Budget 
– Sales are 40% Cash and 60% Credit. Of the credit sales, 30% are collected the next month, 40% the month after, and 25% the month after that, and 5% are determined to be uncollectible.
– Your account receivable total from your balance sheet will be collected as follows: 40% the next month, 40% in two months, 15% in three months, and 5% is determined to be uncollectible.
– 50% of your account payable total is inventory bought on account which you pay for the next month.
– Whatever your inventory total is on your balance sheet, you must keep 20% of this as ending inventory each month (Like the example we did in class).
– You must maintain 10% of your cash total from you balance sheet in your cash account (This applies to the cash budget).Building on the corrections suggested (if any) from Part II, Part III of the term assignment continues with the Master Budget by completing the budgeted income statement and budgeted balance sheet. From these statements, students will then make a flexible budget and answer a set of questions leading up to the final submission.
Part 3 
Question Set 1:
1) Complete the budgeted income statement and balance sheet for the three month period.
2) Use your budgeted income statement and create a flexible budget for a 5% and 10% increase in sales and decrease in sales. 
3) What changes did you notice to your Cash Budget when you inserted the new sales figures? 
Question Set 2:
1) List 3 non-financial goals that your company may use in a balanced scorecard.
2) Go to the the Management Discussion and Analysis section in the annual report of your company (If one exists). What long term financial goals are outlined?
3) Using your budget and the strategic/long range goals, what advice can you give the managerial accountant of your company going forward?