Please complete the three sheets of excel.

AutoSave OF AvcGF... Chapter 11 HW (Empty) Home Insert Draw Page Layout Formulas Data Review View Tell me Share Comments Calibrl (body) v 12 ~ Al A ab Wran Text y General Insert v v X [G 4YO AY F Paste B 1 U * CA A = = = - - Merge & Center Delete Format Conditional Format Cell Formatting as Table Styles Sort & Filte Sensitivity Analyze Data Find & Select y F16 T x x A D F F G H 1 1 K M N P Q Q 3 S T SUBARU 2 3 4 5 6 7 Subaru Company had the following accounts and account balances as of March 31, 20xx. Use these data to complete the partial balance sheet below. Comman Stock Par value (per sharel $0.20 Shares issued 766,750 Additional Paid in Capital $160,178 Treasury Shares Purchase Price per Share $9.50 Number of Treasury Shares 6,726 Retained Earnires $1,397,239 Subaru Company Balance Sheet (Partial) As of March 31, 20XX 10 12 13 14 15 16 17 18 15 20 9 22 23 24 25 26 27 28 29 30 3 32 33 Q1 Q2 Q3 + Ready S: + 100% AutoSave OF AvcGF... Chapter 11 HW (Empty) Home Insert Draw Page Layout Formulas Data Review View Tell me Share Comments General v Insert v X [G : WE AYO Paste Calibri (body) v 12 vi 92 ab Wran Text BIUM A Merge & Center fx What is the per share amount of dividend paid to common stock holders? ? % Delete Format Conditional Format Cell Formatting as Table Styles Sensitivity Find & Select Sort & Filter Analyze Data y B36 + x T A c D F F G H 1 ] K L M N 0 P Q 9 10 11 During 20XX, the corporation had the following transactions and events pertaining to its stockholders' equity: March 1: Issued 6,100 shares of common stack for $90 per shere. June 22: Re-issued 1,100 shares of comman treasury stock at $0 per share. 12 13 Dec 1: Dedared a cash dividend of $157,120 to stockholders of record on December 15, payable December 31, 2022. Dec 21: Determined that net income for the year was $125,000. 14 Using these data complete the partial balance sheet below as of December 31, 20XX. 15 16 Tesla Inc 17 Balance Sheet(Partiall 18 As of Dec 31, 20XX 19 Stockholder's Equity 20 Common Stock 22 Preferred Stack 22 Additional Paid in Capital -Comman Stock 23 Additional Paic-in Capital - Preferred Stock 24 Retained Earnings 25 Less: Treasury Stock 26 Total Stockholder's cquity 28 29 Answer the following questions related questions: 30 How many shares of common stock are issued as of Dec 31, 20/Oc? 31 How many shares of common stock are outstanding as of Dec 31, 20XX? 32 How many shares of preferred stack are issued as of Dec 31, 20XX? 33 How many shares of preferred stock are outstanding as of Dec 31, 20xX? 34 How much of the Dec 1 cash dividend went to preferred stockholders? 35 How much of the Dec 1 cash dividend went to common stockholders? 36 What is the per share amount of cividend paid to common stock holders? 37 What is total contributed capital as of Dec 31, 20XX? 38 3S 40 41 92 43 44 45 01 02 Q3 + Ready S: + 100% AutoSave OF AvcGF... Chapter 11 HW (Empty) Insert Draw Page Layout Formulas Data Home - Review View Tell me Share Comments X Calibri (Body) v 12 ~ A A ab Wran Text y General Insert v v 4YO F Paste B 1 Uv CA A = = = Merge & Center $ -% Delete Format Conditional Format Cell Formatting as Table Styles Sort & Filter Find & Select Analyze Data Sensitivity y G9 1 x fx 7 4 D F G H 1 L M N N P R 5 5 T U V Ford 2 2 3 4 5 5 6 The following financial information is available for Ford: Iti millions) Current Year Average common stackholders' equity $2,5CO $ Dividends declared for common stockholders 294 Dividends declared for preferred stockholders 35 Net Income 500 Prior Year $2,575 638 35 550 2 Calculate the payout ratio and retum on common stockholders' equity for the current year and the prior year. Current Year Prior Year Payout Ratio Return on Common Stockholders' Equity 9 9 10 1: 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 25 01 Q2 Q3 + Ready S: + 100% AutoSave OF AvcGF... Chapter 11 HW (Empty) Home Insert Draw Page Layout Formulas Data Review View Tell me Share Comments Calibrl (body) v 12 ~ Al A ab Wran Text y General Insert v v X [G 4YO AY F Paste B 1 U * CA A = = = - - Merge & Center Delete Format Conditional Format Cell Formatting as Table Styles Sort & Filte Sensitivity Analyze Data Find & Select y F16 T x x A D F F G H 1 1 K M N P Q Q 3 S T SUBARU 2 3 4 5 6 7 Subaru Company had the following accounts and account balances as of March 31, 20xx. Use these data to complete the partial balance sheet below. Comman Stock Par value (per sharel $0.20 Shares issued 766,750 Additional Paid in Capital $160,178 Treasury Shares Purchase Price per Share $9.50 Number of Treasury Shares 6,726 Retained Earnires $1,397,239 Subaru Company Balance Sheet (Partial) As of March 31, 20XX 10 12 13 14 15 16 17 18 15 20 9 22 23 24 25 26 27 28 29 30 3 32 33 Q1 Q2 Q3 + Ready S: + 100% AutoSave OF AvcGF... Chapter 11 HW (Empty) Home Insert Draw Page Layout Formulas Data Review View Tell me Share Comments General v Insert v X [G : WE AYO Paste Calibri (body) v 12 vi 92 ab Wran Text BIUM A Merge & Center fx What is the per share amount of dividend paid to common stock holders? ? % Delete Format Conditional Format Cell Formatting as Table Styles Sensitivity Find & Select Sort & Filter Analyze Data y B36 + x T A c D F F G H 1 ] K L M N 0 P Q 9 10 11 During 20XX, the corporation had the following transactions and events pertaining to its stockholders' equity: March 1: Issued 6,100 shares of common stack for $90 per shere. June 22: Re-issued 1,100 shares of comman treasury stock at $0 per share. 12 13 Dec 1: Dedared a cash dividend of $157,120 to stockholders of record on December 15, payable December 31, 2022. Dec 21: Determined that net income for the year was $125,000. 14 Using these data complete the partial balance sheet below as of December 31, 20XX. 15 16 Tesla Inc 17 Balance Sheet(Partiall 18 As of Dec 31, 20XX 19 Stockholder's Equity 20 Common Stock 22 Preferred Stack 22 Additional Paid in Capital -Comman Stock 23 Additional Paic-in Capital - Preferred Stock 24 Retained Earnings 25 Less: Treasury Stock 26 Total Stockholder's cquity 28 29 Answer the following questions related questions: 30 How many shares of common stock are issued as of Dec 31, 20/Oc? 31 How many shares of common stock are outstanding as of Dec 31, 20XX? 32 How many shares of preferred stack are issued as of Dec 31, 20XX? 33 How many shares of preferred stock are outstanding as of Dec 31, 20xX? 34 How much of the Dec 1 cash dividend went to preferred stockholders? 35 How much of the Dec 1 cash dividend went to common stockholders? 36 What is the per share amount of cividend paid to common stock holders? 37 What is total contributed capital as of Dec 31, 20XX? 38 3S 40 41 92 43 44 45 01 02 Q3 + Ready S: + 100% AutoSave OF AvcGF... Chapter 11 HW (Empty) Insert Draw Page Layout Formulas Data Home - Review View Tell me Share Comments X Calibri (Body) v 12 ~ A A ab Wran Text y General Insert v v 4YO F Paste B 1 Uv CA A = = = Merge & Center $ -% Delete Format Conditional Format Cell Formatting as Table Styles Sort & Filter Find & Select Analyze Data Sensitivity y G9 1 x fx 7 4 D F G H 1 L M N N P R 5 5 T U V Ford 2 2 3 4 5 5 6 The following financial information is available for Ford: Iti millions) Current Year Average common stackholders' equity $2,5CO $ Dividends declared for common stockholders 294 Dividends declared for preferred stockholders 35 Net Income 500 Prior Year $2,575 638 35 550 2 Calculate the payout ratio and retum on common stockholders' equity for the current year and the prior year. Current Year Prior Year Payout Ratio Return on Common Stockholders' Equity 9 9 10 1: 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 25 01 Q2 Q3 + Ready S: + 100%