Can you complete this financial statement analysis
ACCT 711 – Project on Financial Statement Analysis. FedEx is a popular global firm, located in Tennessee. You are given financial statements of FedEx and UPS for several years. Answer the following questions using these financial statements: Question 1. This question has 2 parts: Part a. (1.5 points) Prepare the common size income statement for the firms (both FedEx and UPS) and for the years 2012 through 2021 (you can copy the statements in sheet "Income Statement" and then prepare the Common Size Income Statements). Part b. (1.5 points) Prepare the common size Balance Sheet for the firms (both FedEx and UPS) for the years 2012 through 2021 (you can copy the Balance Sheets in sheet "Balance Sheet" and then prepare the Common Size Balance Sheet). Question 2. (3 points). Analyze the financial performance of each company over the last 5 years? Comment on the change in the financial position of each company during this last 5-year period. You can use the above common size income statements and balance sheets, or any other information provided in the statements. You should analyze the evolution of firms’ profitability, liquidity/solvency, asset management (asset turnover). Question 3. (6 points). Compare the performance of these two firms. Your answer should state which firm has better performance over the last 5 years? Which firm has a sounder financial position over the last 5 years? Which firm seems to manage its assets more efficiently? Provide evidence to support your conclusion? Instructions (See the “MBA SLO4-Critical Thinking” for Rubrics): Type your answers in a word file, then upload your work on Canvas. Due date: See the syllabus Key Stats United Parcel Service, Inc. (NYSE:UPS) > Financials > Key Stats In Millions of the trading currency, except per share items.Currency:Trading Currency Conversion:Today's Spot Rate Order:Latest on Right Units:S&P Capital IQ (Default) Decimals:Capital IQ (Default) Dilution:Basic Key Financials¹ For the Fiscal Period Ending 12 months Dec-31-2012A12 months Dec-31-2013A12 months Dec-31-2014A12 months Dec-31-2015A12 months Dec-31-2016A12 months Dec-31-2017A12 months Dec-31-2018A12 months Dec-31-2019A12 months Dec-31-2020A12 months Dec-31-2021A12 months† Dec-31-2022E12 months Dec-31-2023E12 months Dec-31-2024E CurrencyUSDUSDUSDUSDUSDUSDUSDUSDUSDUSDUSDUSDUSD Total Revenue54,127.055,438.058,232.058,363.061,610.066,585.071,861.074,094.084,628.097,287.0101,761.83105,523.25107,707.87 Growth Over Prior Year1.9%2.4%5.0%0.2%5.6%8.1%7.9%3.1%14.2%15.0%4.60%3.70%2.07% Gross Profit7,451.013,178.012,531.014,388.011,708.013,866.013,130.013,629.011,490.026,867.0--- Margin %13.8%23.8%21.5%24.7%19.0%20.8%18.3%18.4%13.6%27.6%16.76%16.81%16.20% EBITDA3,201.08,940.07,993.09,752.07,089.08,811.07,665.07,807.04,794.019,221.017,082.7217,689.8317,190.82 Margin %5.9%16.1%13.7%16.7%11.5%13.2%10.7%10.5%5.7%19.8%16.79%16.76%15.96% EBIT1,343.07,073.06,070.07,668.04,865.06,529.05,458.05,447.02,096.016,268.013,994.2514,516.8814,405.79 Margin %2.5%12.8%10.4%13.1%7.9%9.8%7.6%7.4%2.5%16.7%13.75%13.76%13.37% Earnings from Cont. Ops.807.04,372.03,032.04,844.03,422.04,905.04,791.04,440.01,343.012,890.0--- Margin %1.5%7.9%5.2%8.3%5.6%7.4%6.7%6.0%1.6%13.2%--- Net Income807.04,372.03,032.04,844.03,422.04,905.04,791.04,440.01,343.012,890.011,238.1211,629.6811,591.05 Margin %1.5%7.9%5.2%8.3%5.6%7.4%6.7%6.0%1.6%13.2%11.04%11.02%10.76% Diluted EPS Excl. Extra Items³0.834.613.285.353.865.615.515.111.5414.6812.8513.3813.63 Growth Over Prior Year(78.4%)455.4%(28.9%)63.1%(27.9%)45.3%(1.8%)(7.3%)(69.9%)853.2%5.94%4.14%1.85% ¹All results are taken from the most recently filed statement for each period. When there has been more than one, earlier filings can be viewed on the individual statement pages. ³All forward period figures are consensus mean estimates provided by the brokers and may not be on a comparable basis as financials. †Growth rates for forward periods are calculated against prior period estimates or actual pro forma results as disclosed on the Estimates Consensus page. Current Capitalization (Millions of USD) CurrencyUSD Share Price$203.41 Shares Out.870.4 Market Capitalization177,046.3 - Cash & Short Term Investments10,604.0 + Total Debt25,538.0 + Pref. Equity- + Total Minority Interest16.0 - Long Term Marketable Securities- = Total Enterprise Value (TEV)191,996.3 Book Value of Common Equity14,253.0 + Pref. Equity- + Total Minority Interest16.0 + Total Debt25,538.0 = Total Capital39,807.0 **For companies that have multiple share classes that publicly trade, we are incorporating the different prices to calculate our company level market capitalization. Please click on the value to see the detailed calculation. Prices shown on this page are the close price of the company’s primary stock class. Shares shown on this page are total company as-reported share values. Total Liability includes Total Debt, Minority Interest and Pref. Equity. Net Liability includes Total Liability, net of Cash and Short Term Investments. TEV includes Market Cap and Net Liability. Total Capital includes Common Equity and Total Liability. Valuation Multiples based on Current Capitalization For the Fiscal Period Ending 12 months Dec-31-2020A12 months Dec-31-2021A12 months Dec-31-2022E12 months Dec-31-2023E12 months Dec-31-2024E TEV/Total Revenue2.3x2.0x1.89x1.82x1.78x TEV/EBITDA27.2x8.8x11.24x10.85x11.17x TEV/EBIT91.6x11.8x13.72x13.23x13.33x P/Diluted EPS Before Extra132.1x13.9x15.83x15.20x14.92x P/BV267.8x12.4x9.00x7.17x6.78x Price/Tang BVNM21.9x--- Income Statement United Parcel Service, Inc. (NYSE:UPS) > Financials > Income Statement In Millions of the reported currency, except per share items.Template:Standard Restatement:Latest Filings Period Type:Annual Order:Latest on Right Currency:Reported Currency Conversion:Today's Spot Rate Units:S&P Capital IQ (Default) Decimals:Capital IQ (Default) Source:Capital IQ & Proprietary Data Income Statement For the Fiscal Period Ending Reclassified 12 months Dec-31-2012Reclassified 12 months Dec-31-2013Reclassified 12 months Dec-31-2014Reclassified 12 months Dec-31-2015Restated 12 months Dec-31-2016Restated 12 months Dec-31-2017Reclassified 12 months Dec-31-2018Reclassified 12 months Dec-31-2019Reclassified 12 months Dec-31-202012 months Dec-31-2021 CurrencyUSDUSDUSDUSDUSDUSDUSDUSDUSDUSD Revenue54,127.055,438.058,232.058,363.061,610.066,585.071,861.074,094.084,628.097,287.0 Other Revenue---------- Total Revenue54,127.055,438.058,232.058,363.061,610.066,585.071,861.074,094.084,628.097,287.0 Cost Of Goods Sold46,676.042,260.045,701.043,975.049,902.052,719.058,731.060,465.073,138.070,420.0 Gross Profit7,451.013,178.012,531.014,388.011,708.013,866.013,130.013,629.011,490.026,867.0 Selling General & Admin Exp.---------- R & D Exp.---------- Depreciation & Amort.1,858.01,867.01,923.02,084.02,224.02,282.02,207.02,360.02,698.02,953.0 Other Operating Expense/(Income)4,250.04,238.04,538.04,636.04,619.05,055.05,465.05,822.06,696.07,646.0 Other Operating Exp., Total6,108.06,105.06,461.06,720.06,843.07,337.07,672.08,182.09,394.010,599.0 Operating Income1,343.07,073.06,070.07,668.04,865.06,529.05,458.05,447.02,096.016,268.0 Interest Expense(393.0)(380.0)(353.0)(341.0)(381.0)(453.0)(605.0)(653.0)(701.0)(694.0) Interest and Invest. Income24.020.08.08.0632.01,060.01,451.01,121.01,558.01,386.0 Net Interest Exp.(369.0)(360.0)(345.0)(333.0)251.0607.0846.0468.0857.0692.0 Currency Exchange Gains (Loss)--14.07.05.03.0(19.0)(6.0)9.0(36.0) Other Non-Operating Inc. (Exp.)---------- EBT Excl. Unusual Items974.06,713.05,739.07,342.05,121.07,139.06,285.05,909.02,962.016,924.0 Restructuring Charges------(262.0)(166.0)(348.0)(380.0) Merger & Related Restruct. Charges-(284.0)-------- Impairment of Goodwill--------(494.0)- Gain (Loss) On Sale Of Invest.-----(2.0)(4.0)6.05.05.0 Gain (Loss) On Sale Of Assets-245.0-------46.0 Asset Writedown--------(192.0)- Legal Settlements-------(97.0)-- Other Unusual Items--(1,102.0)-----(89.0)- EBT Incl. Unusual Items974.06,674.04,637.07,342.05,121.07,137.06,019.05,652.01,844.016,595.0 Income Tax Expense167.02,302.01,605.02,498.01,699.02,232.01,228.01,212.0501.03,705.0 Earnings from Cont. Ops.807.04,372.03,032.04,844.03,422.04,905.04,791.04,440.01,343.012,890.0 Earnings of Discontinued Ops.---------- Extraord. Item & Account. Change---------- Net Income to Company807.04,372.03,032.04,844.03,422.04,905.04,791.04,440.01,343.012,890.0 Minority Int. in Earnings---------- Net Income807.04,372.03,032.04,844.03,422.04,905.04,791.04,440.01,343.012,890.0 Pref. Dividends and Other Adj.---------- NI to Common Incl Extra Items807.04,372.03,032.04,844.03,422.04,905.04,791.04,440.01,343.012,890.0 NI to Common Excl. Extra Items807.04,372.03,032.04,844.03,422.04,905.04,791.04,440.01,343.012,890.0 Per Share Items Basic EPS$0.84$4.65$3.31$5.38$3.88$5.63$5.53$5.14$1.55$14.75 Basic EPS Excl. Extra Items0.844.653.315.383.885.635.535.141.5514.75 Weighted Avg. Basic Shares Out.960.0940.0916.0901.0883.0871.0866.0864.0867.0874.0 Diluted EPS$0.83$4.61$3.28$5.35$3.86$5.61$5.51$5.11$1.54$14.68 Diluted EPS Excl. Extra Items0.834.613.285.353.865.615.515.111.5414.68 Weighted Avg. Diluted Shares Out.969.0948.0924.0906.0887.0875.0870.0869.0871.0878.0 Normalized Basic EPS$0.63$4.46$3.92$5.09$3.62$5.12$4.54$4.27$2.14$12.1 Normalized Diluted EPS0.634.433.885.063.615.14.524.252.1312.05 Dividends per Share$2.28$2.48$2.68$2.92$3.12$3.32$3.64$3.84$4.04$4.08 Payout Ratio %263.9%51.7%78.0%52.1%77.2%56.5%62.8%71.9%251.2%26.7% Shares per Depository Receipt0.0630.0630.0630.0630.0630.0630.0630.0630.0630.063 Supplemental Items EBITDA3,201.08,940.07,993.09,752.07,089.08,811.07,665.07,807.04,794.019,221.0 EBITA1,587.07,258.06,265.07,929.05,186.06,816.05,797.05,824.02,512.016,743.0 EBIT1,343.07,073.06,070.07,668.04,865.06,529.05,458.05,447.02,096.016,268.0 EBITDAR3,820.09,515.08,669.010,421.07,775.09,615.08,624.09,778.07,051.021,706.0 Effective Tax Rate %17.1%34.5%34.6%34.0%33.2%31.3%20.4%21.4%27.2%22.3% Current Domestic Taxes2,083.02,386.01,035.01,722.01,405.0720.096.0753.0939.01,582.0 Current Foreign Taxes167.0162.0185.0236.0177.0288.0374.0359.0420.0478.0 Total Current Taxes2,250.02,548.01,220.01,958.01,582.01,008.0470.01,112.01,359.02,060.0 Deferred Domestic Taxes(2,072.0)(264.0)416.0534.0128.01,233.0743.0162.0(884.0)1,584.0 Deferred Foreign Taxes(11.0)18.0(31.0)6.0(11.0)(9.0)15.0(62.0)26.061.0 Total Deferred Taxes(2,083.0)(246.0)385.0540.0117.01,224.0758.0100.0(858.0)1,645.0 Normalized Net Income608.84,195.63,586.94,588.83,200.64,461.93,928.13,693.11,851.310,577.5 Interest Capitalized18.014.011.013.014.0NANANA87.058.0 Interest on Long Term DebtNANANANANANANA19.0105.072.0 Non-Cash Pension Expense4,056.0(540.0)548.0(542.0)2,096.0(154.0)387.01,478.04,840.0(4,564.0) Filing DateFeb-27-2015Feb-25-2016Feb-21-2017Feb-21-2018Feb-21-2019Feb-20-2020Feb-22-2021Feb-22-2022Feb-22-2022Feb-22-2022 Restatement TypeRCRCRCRCRSRSRCRCRCO Calculation TypeREPREPREPREPREPREPREPREPREPREP Supplemental Operating Expense Items Net Rental Exp.619.0575.0676.0669.0686.0804.0959.01,971.02,257.02,485.0 Imputed Oper. Lease Interest Exp.169.1151.6180.6150.4142.3144.2197.1404.1508.6560.9 Imputed Oper. Lease Depreciation449.9423.4495.4518.6543.7659.8761.91,566.91,748.41,924.1 Maintenance & Repair Exp.1,228.01,240.01,371.01,400.01,542.01,601.01,732.01,838.02,365.02,443.0 Stock-Based Comp., Unallocated547.0513.0536.0574.0591.0584.0634.0915.0796.0878.0 Stock-Based Comp., Total547.0513.0536.0574.0591.0584.0634.0915.0796.0878.0 Note: For multiple class companies, per share items are primary class equivalent, and for foreign companies listed as primary ADRs, per share items are ADR-equivalent. Balance Sheet United Parcel Service, Inc. (NYSE:UPS) > Financials > Balance Sheet In Millions of the reported currency, except per share items.Template:Standard Restatement:Latest Filings Period Type:Annual Order:Latest on Right Currency:Reported Currency Conversion:Today's Spot Rate Units:S&P Capital IQ (Default) Decimals:Capital IQ (Default) Source:Capital IQ & Proprietary Data Balance Sheet Balance Sheet as of: Dec-31-2012Dec-31-2013Restated Dec-31-2014Dec-31-2015Dec-31-2016Restated Dec-31-2017Dec-31-2018Dec-31-2019Dec-31-2020Dec-31-2021 CurrencyUSDUSDUSDUSDUSDUSDUSDUSDUSDUSD ASSETS Cash And Equivalents7,327.04,665.02,291.02,730.03,476.03,320.04,225.05,238.05,910.010,255.0 Short Term Investments597.0580.0992.01,996.01,091.0749.0810.0503.0406.0338.0 Trading Asset Securities1.07.0---1.01.02.02.011.0 Total Cash & ST Investments7,925.05,252.03,283.04,726.04,567.04,070.05,036.05,743.06,318.010,604.0 Accounts Receivable6,111.06,502.06,661.07,134.07,695.08,943.09,192.09,824.011