Above are the pages 47-48 described in the assignment. Assignment must be done in Excel

In an Excel document, prepare the following financial statements for the mini-case Cash Flows and Financial Statements at Sunset Boards, Inc. on pages 47 and 48 of the textbook:

Income Statement for 2014 and 2015

Balance Sheet for 2014 and 2015

In the Excel document, also calculate:

the Operating Cash Flow for each year

the Cash Flow from Assets for 2015

the Cash Flow to Creditors for 2015

the Cash Flow to Stockholders for 2015

Tad Marks, the companys founder, is considering expanding the business, which will require a substantial investment. Evaluate the financial statements you have developed and Sunset Boards cash flow. In your Excel document or a separate Word document, write a paragraph explaining whether you feel expansion would be a wise choice and why.

EXCEL MASTER IT! PROBLEM Using Excel to find the marginal tax rate can be accomplished using the VLOOKUP function. However, calculating the total tax bill is a ittle more difficult. Below we have shown a copy of the IRS tax table for an individual for 2014. Often, tax tables are presented in this format If taxable income is But not over over. The tax is: $ 10% of the amount over $0 $907.50 plus 15% of the amount over $9,075 $5,081.25 plus 25% of the amount over $36,900 $18,193.75 plus 28% of the amount over $89,350 $45,353.75 plus 33% of the amount over $186,350 $117,541.25 plus 35% of the amount over S405,100 $118,118.75 plus 39.6% of the amount over $406,750 9,075 9,075 36,900 83,350 186,350 405,100 406,750 36,900 83,350 186.350 405,100 406,750 In reading this table, the marginal tax rate for taxable income less than $9,075 is 10 percent. If the taxable income is between $9,075 and $36,900, the tax bill is 907.50 plus the marginal taxes. The marginal taxes are calculated as the taxable income minus $9,075 times the marginal tax rate of 15 percent