please focus on the requirment :"Use an Excel spreadsheet and/or tables to present your calculations. Show all workings."

and the style of the reference is (APA),

At the end of its third year of operations, the Sandifer Manufac-turing Company had:

$4,500,000 in revenue;

$3,375,000 in cost of goods sold;

$450,000 in operating expenses, which included a depre-ciation expense of $150,000;

a tax liability equal to 30% of the firm's taxable income.

a. Construct an Income Statement with the above data.

b. What is the net profit of the firm for the year?

c. Explain how net profit differs from gross profit and operating profit?

d. Analyse the data and outcome. What information can we de-rive from Sandifer's Income Statement?

Continued from Part 1: Sandifer Manufacturing Company (from the previous problem) plans to reinvest $50,000 of its earnings back in the firm.

How much profit is left for the payment of a cash dividend to Sandifer's shareholders?

sencond one : Liquidity Analysis Calculation: The King Carpet Company has $3, 000, 000 in cash and a total of $12,000,000 in current assets. The firm's current liabilities equal $6,000,000 such that the firm's current ratio equals 2. The company's managers want to reduce the firm's cash holdings to $1,000,000 by paying $500,000 in cash to expand the firm's truck fleet, and using $1,500,000 in cash to retire a short-term note. Central to the decisions is the issue of liquidity.

a. What does the term liquidity mean in the context of the firm's financial condition?

b. What financial ratios can you use to analyse and assess li-quidity?

c. If they carry this plan through, demonstrate the effect on the firm's current ratio?

d. How we can we determine whether The King Carpet Com-pany is more or less liquid than other firms?

Profitability Analysis Calculation: The Allen Corporation had sales in 2015 of $65 million, total assets of $42 million and total liabilities of $20 million. The annual interest rate on the company's debt is 6%, and its tax rate is 30%. The operating profit margin is 12%.

a. Compute the firm's 2015 operating profit and net profit.

b. How would you determine if the frim was achieving rea-sonable profit margins?

c. Calculate the firm's return on assets and return on equity (hint: you can assume that interest must be paid on all of the firm's liabilities) and describe what aspect of the firm's per-formance you are measuring.