Complete and submit Assignment $6$ Data Analytics Assignment This assignment is to be completed individually. Your instructor will provide you with a Data Analytics Excel spreadsheet. Rename the file as Lastname$\_$Assignment$6.$ Calculate the following variables and store them as new columns in your file. $$Submit by uploading your completed file to this assignment. Net Income Attributable to Common Shareholders $($NIAC$)=$ Net income $$ Noncontrolling interest on income statement Operating Assets $($OpAssets$)=$ Total Assets $$ Cash and short$-$term investments Operating Liabilities $($OpLiab$)=$ Total liabilities $$ Total debt Net Operating Assets $($NOA$)=$ Operating Assets $$ Operating Liabilities Net Operating Profit Before Tax $($NOPBT$)=$ Pretax Income $+$ Interest Expense $$ Interest Income Tax rate $=22\%$ for $2018$ onward, $37\%$ for years prior to $2018$ Tax on Operating Profit $($TaxOperProf$)=$ Tax Expense $+$ Tax Rate x $($Interest Expense $$ Interest Income$)$ Net Operating Profit After Tax $($NOPAT$)=$ NOPBT $$ Tax on Operating Profit Return on Equity $($ROE$)$ Return on Assets $($ROA$)$ Return on Net Operating Assets $($RNOA$)$ Check figures for company DR Horton, year $2004$: ROE $=24\mathrm{.}62\%$ ROA $=10\mathrm{.}85\%-$