Question

1 Approved Answer

Posted on Jul 27, 2024

Step 1: Collect the annual financial report of new jersey resources corporation. Step 2: Please calculate all ratios of that company. Calculate all the ratios

Step 1: Collect the annual financial report of new jersey resources corporation.

Step 2: Please calculate all ratios of that company. Calculate all the ratios in an Excel File. You need to show all your calculations in an excel file but use the calculated value in your main report.

Step 3: Investigation Year- From 2016 to 2019 (Before Covid19) and 2020 (After Covid19 attack / during a pandemic). Total 5-year ratios.

Step 4: Explain and analyze the Debt total asset, long-term debt total asset ratio, cash equity ratio (you have calculated in step 2) for new jersey resources corporation by concentration before Covid19 and after the Covid19 attack.

image text in transcribed

- Cla . New Microsoft Office Excel Worksheet (2).xlsx - Microsoft Excel Home Insert Page Layout Formulas Data Review View n! Calibri Wrap Text General * Cut E) Copy Paste Format Painter Clipboard BI U Merge & Center : :08 Insert Delete Format Conditional Format Cell Formatting as Table Styles Styles AutoSum Fill Sort & Find & 2 Clear - Filter - Select Editing Font Alignment Number Cells E41 fx B D E F G H 1 J K L M N 0 2016 2017 2018 2019 2020 1 ABC Co. 2 Income Statement 3 Sales (90% credit sales) 4 COGS 5 Gross Profit 6 Selling & Admin 7 Operating Profit 8 Interest Expense 9 Other income (Expense) 10 Net Income before tax 11 Taxes 4000000 3000000 1000000 450000 550000 50000 -225000 275000 75000 200000 12 Net Income 13 14 ABC Co. Balance Sheet 15 2016 2017 2018 2019 2020 16 Assets 17 Cash 18 Marketable Securities Sheet1 30000 50000 Ready BO 140% ?? la c) ** ENG 9:34 PM 8/2/2021 - Cla . New Microsoft Office Excel Worksheet (2).xlsx - Microsoft Excel Home Insert Page Layout Formulas Data Review X View n! AutoSum - Calibri 11 Wrap Text General Fill - * Cut En Copy Paste Format Painter Clipboard B I U *Merge & Center $ - % .00 .00 .0 Insert Delete Format Conditional Format Cell Formatting as Table Styles Styles 2 Clear Sort & Find & Filter Select Editing Font Alignment Number Cells E41 fox E F G . I J J K M N 0 P P Q Q 2016 2017 2018 2019 2020 30000 50000 350000 370000 800000 800000 1600000 A B B D 14 ABC Co. 15 Balance Sheet 16 Assets 17 Cash 18 Marketable Securities 19 Account Receivable 20 Inventory 21 Total Current Assets 22 Net Plan & Equipment 23 Total Assets 24 25 Liabilities & Stockholder's Equity 26 Accounts Payable 27 Notes Payable 28 Total Current Liabilities 29 Long-term liabilities 30 Total Liabilities 31 Common Stock 32 Retained Earnings 33 Total Liabilities & Stockholder's Equity 34 Sheet1 50000 250000 300000 300000 600000 400000 600000 1600000 1111 Ready B!! O 120% O wa ?? Ca ) * ENG 9:34 PM 8/2/2021 - Cla . New Microsoft Office Excel Worksheet (2).xlsx - Microsoft Excel Home Insert Formulas Page Layout Data Review X View n! AutoSum - Calibri 11 Wrap Text General Fill - * Cut En Copy Paste Format Painter Clipboard B I U *Merge & Center $ - % .00 .00 .0 Insert Delete Format Conditional Format Cell Formatting as Table Styles Styles 2 Clear - Sort & Find & Filter Select Editing Font Alignment Number Cells E40 fic (E21-E20)/E28 A B D E F F G . J J K L M M N 0 P P Q Q 35 2017 2018 2019 2020 Workings: 36 Ratios 37 Profit Margine in % 38 Return on Assets in % 39 Average collection period in days 40 Quick Ratio in times 2016 5 12.5 35 1.43333 Avg daily credit sales 10000 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 Sheet1 1111 Ready B!! O 120% O e Bi wa ?? Ca ) * ENG 9:35 PM 8/2/2021 - Cla . New Microsoft Office Excel Worksheet (2).xlsx - Microsoft Excel Home Insert Formulas Page Layout Data Review X View n! AutoSum - Wrap Text General Fill - Merge & Center $ - % .00 .00 .0 Insert Delete Format Conditional Format Cell Formatting as Table Styles Styles 2 Clear Sort & Find & Filter Select Editing Alignment Number Cells F G . J J K L M M N 0 P P Q Q * Cut Calibri 11 En Copy Paste B I U Format Painter Clipboard Font M39 foc -4000000*90%/360 A B D E 35 36 Ratios 2016 37 Profit Margine in % 5 38 Return on Assets in % 12.5 39 Average collection period in days 35 40 Quick Ratio in times 1.43333 41 42 2017 2018 2019 2020 Workings: Avg daily credit sales 10000 43 44 45 46 47 48 49 50 51 52 53 54 55 Sheet1 1111 Ready B!! O 120% O e Bi wa ?? Ca ) * ENG 9:35 PM 8/2/2021 New Microsoft Office Excel Worksheet (2).xlsx - Microsoft Excel Home Insert Page Layout Formulas Data Review View Calibri 11 AA Wrap Text General B I U 2 Merge & Center - $ - % *: .. 4. Cut Ea Copy Paste Format Painter Clipboard E41 Insert Conditional Format Cell Formatting as Table Styles Styles Font Alignment Number fox B C D E F G H J 2017 2018 2019 2020 1 ABC Co. 2 Income Statement 3 Sales (90% credit sales) 4 COGS 5 Gross Profit 6 Selling & Admin 7 Operating Profit 8 Interest Expense 9 Other income (Expense) 10 Net Income before tax 11 Taxes 12 Net Income 13 2016 4000000 3000000 1000000 450000 550000 50000 -225000 275000 75000 200000 B / Sera Merge & Center $ % Insert Delete Format Paste Format Painter Clipboard :8 .. Conditional Format Cell Formatting as Table Styles Styles Font Alignment Number Cells E41 E F G H 1 J K L M 2016 2017 2018 2019 2020 30000 50000 350000 370000 800000 A B D 14 ABC Co. 15 Balance Sheet 16 Assets 17 Cash 18 Marketable Securities 19 Account Receivable 20 Inventory 21 Total Current Assets 22 Net Plan & Equipment 23 Total Assets 24 25 Liabilities & Stockholder's Equity 26 Accounts Payable 27 Notes Payable 28 Total Current Liabilities 29 Long-term liabilities 30 Total Liabilities 31 Common Stock 32 Retained Earnings 33 Total Liabilities & Stockholder's Equity 800000 1600000 50000 250000 300000 300000 600000 400000 600000 1600000 24 - Cla . New Microsoft Office Excel Worksheet (2).xlsx - Microsoft Excel Home Insert Page Layout Formulas Data Review View n! Calibri Wrap Text General * Cut E) Copy Paste Format Painter Clipboard BI U Merge & Center : :08 Insert Delete Format Conditional Format Cell Formatting as Table Styles Styles AutoSum Fill Sort & Find & 2 Clear - Filter - Select Editing Font Alignment Number Cells E41 fx B D E F G H 1 J K L M N 0 2016 2017 2018 2019 2020 1 ABC Co. 2 Income Statement 3 Sales (90% credit sales) 4 COGS 5 Gross Profit 6 Selling & Admin 7 Operating Profit 8 Interest Expense 9 Other income (Expense) 10 Net Income before tax 11 Taxes 4000000 3000000 1000000 450000 550000 50000 -225000 275000 75000 200000 12 Net Income 13 14 ABC Co. Balance Sheet 15 2016 2017 2018 2019 2020 16 Assets 17 Cash 18 Marketable Securities Sheet1 30000 50000 Ready BO 140% ?? la c) ** ENG 9:34 PM 8/2/2021 - Cla . New Microsoft Office Excel Worksheet (2).xlsx - Microsoft Excel Home Insert Page Layout Formulas Data Review X View n! AutoSum - Calibri 11 Wrap Text General Fill - * Cut En Copy Paste Format Painter Clipboard B I U *Merge & Center $ - % .00 .00 .0 Insert Delete Format Conditional Format Cell Formatting as Table Styles Styles 2 Clear Sort & Find & Filter Select Editing Font Alignment Number Cells E41 fox E F G . I J J K M N 0 P P Q Q 2016 2017 2018 2019 2020 30000 50000 350000 370000 800000 800000 1600000 A B B D 14 ABC Co. 15 Balance Sheet 16 Assets 17 Cash 18 Marketable Securities 19 Account Receivable 20 Inventory 21 Total Current Assets 22 Net Plan & Equipment 23 Total Assets 24 25 Liabilities & Stockholder's Equity 26 Accounts Payable 27 Notes Payable 28 Total Current Liabilities 29 Long-term liabilities 30 Total Liabilities 31 Common Stock 32 Retained Earnings 33 Total Liabilities & Stockholder's Equity 34 Sheet1 50000 250000 300000 300000 600000 400000 600000 1600000 1111 Ready B!! O 120% O wa ?? Ca ) * ENG 9:34 PM 8/2/2021 - Cla . New Microsoft Office Excel Worksheet (2).xlsx - Microsoft Excel Home Insert Formulas Page Layout Data Review X View n! AutoSum - Calibri 11 Wrap Text General Fill - * Cut En Copy Paste Format Painter Clipboard B I U *Merge & Center $ - % .00 .00 .0 Insert Delete Format Conditional Format Cell Formatting as Table Styles Styles 2 Clear - Sort & Find & Filter Select Editing Font Alignment Number Cells E40 fic (E21-E20)/E28 A B D E F F G . J J K L M M N 0 P P Q Q 35 2017 2018 2019 2020 Workings: 36 Ratios 37 Profit Margine in % 38 Return on Assets in % 39 Average collection period in days 40 Quick Ratio in times 2016 5 12.5 35 1.43333 Avg daily credit sales 10000 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 Sheet1 1111 Ready B!! O 120% O e Bi wa ?? Ca ) * ENG 9:35 PM 8/2/2021 - Cla . New Microsoft Office Excel Worksheet (2).xlsx - Microsoft Excel Home Insert Formulas Page Layout Data Review X View n! AutoSum - Wrap Text General Fill - Merge & Center $ - % .00 .00 .0 Insert Delete Format Conditional Format Cell Formatting as Table Styles Styles 2 Clear Sort & Find & Filter Select Editing Alignment Number Cells F G . J J K L M M N 0 P P Q Q * Cut Calibri 11 En Copy Paste B I U Format Painter Clipboard Font M39 foc -4000000*90%/360 A B D E 35 36 Ratios 2016 37 Profit Margine in % 5 38 Return on Assets in % 12.5 39 Average collection period in days 35 40 Quick Ratio in times 1.43333 41 42 2017 2018 2019 2020 Workings: Avg daily credit sales 10000 43 44 45 46 47 48 49 50 51 52 53 54 55 Sheet1 1111 Ready B!! O 120% O e Bi wa ?? Ca ) * ENG 9:35 PM 8/2/2021 New Microsoft Office Excel Worksheet (2).xlsx - Microsoft Excel Home Insert Page Layout Formulas Data Review View Calibri 11 AA Wrap Text General B I U 2 Merge & Center - $ - % *: .. 4. Cut Ea Copy Paste Format Painter Clipboard E41 Insert Conditional Format Cell Formatting as Table Styles Styles Font Alignment Number fox B C D E F G H J 2017 2018 2019 2020 1 ABC Co. 2 Income Statement 3 Sales (90% credit sales) 4 COGS 5 Gross Profit 6 Selling & Admin 7 Operating Profit 8 Interest Expense 9 Other income (Expense) 10 Net Income before tax 11 Taxes 12 Net Income 13 2016 4000000 3000000 1000000 450000 550000 50000 -225000 275000 75000 200000 B / Sera Merge & Center $ % Insert Delete Format Paste Format Painter Clipboard :8 .. Conditional Format Cell Formatting as Table Styles Styles Font Alignment Number Cells E41 E F G H 1 J K L M 2016 2017 2018 2019 2020 30000 50000 350000 370000 800000 A B D 14 ABC Co. 15 Balance Sheet 16 Assets 17 Cash 18 Marketable Securities 19 Account Receivable 20 Inventory 21 Total Current Assets 22 Net Plan & Equipment 23 Total Assets 24 25 Liabilities & Stockholder's Equity 26 Accounts Payable 27 Notes Payable 28 Total Current Liabilities 29 Long-term liabilities 30 Total Liabilities 31 Common Stock 32 Retained Earnings 33 Total Liabilities & Stockholder's Equity 800000 1600000 50000 250000 300000 300000 600000 400000 600000 1600000 24