hello im doing a financial report analysis for UPS 2021 , something is wrong with my input if someone can please help me.

my optimal capital structure is still showing error signs such as #NUM

thank you

UPS Feb-21 $11,422,000.00 $739.00 $1,670.00 $695,000.00 24.00% 3.64% Inputs Please enter the name of the company you are analyzing: Please enter the date that you are doing this analysis Financial Information Earnings before interest expenses, depreciation & amortization (EBITDA) 6 Depreciation and Amortization: 7 Capital Spending: 8 Interest expense on debt 9 Marginal tax rate to use for pre-tax cost of debt 10 Current Bond Rating on debt (if available) 11 Enter the current pre-tax cost of debt for your company 12 Market Information & Information on debt 13 Number of shares outstanding 14 Market price per share: 15 Beta of the stock: 16 Cash and marketable securities 17 Book value of debt: 18 Can you estimate the market value of the interest bearing debt? 19 so, enter the market value of interest bearing debt: 20 Do you want to estimate market value of debt? 21 yes, enter the weighted average maturity of outstanding debt? 22 Do you have any operating leases? 23 Indirect bankruptcy costs & ratings constraints (if any) 24 Do you want to incorporate indirect bankruptcy costs into your optimal? 25 yes, specify the magnitude of your indirect bankruptcy costs 26 General Market Data 7 727,290,000 $195.05 1.0600 $9.954.00 43,360.00 No S Yes 10.52 ? ask Yes Yes Medium inouts 727,290,000 $195.05 1.0600 ? $9.954.00 43,360.00 $ No Yes 10.52 7 ask Yes 12 Market Information & Information on debt 13 Number of shares outstanding 14 Market price per share 15 Beta of the stock 16 Cash and marketable securities = 17 Book value of debt: 18 Can you estimate the market value of the interest bearing debt? 19 so, enter the market value of "interest bearing" debt: 20 Do you want to estimate market value of debt? 21 \yes, enter the weighted average maturity of outstanding debt? 22 Do you have any operating leases? 23 Indirect bankruptcy costs & ratings constraints (if any) 24 Do you want to incorporate indirect bankruptcy costs into your optimal? 25 if yes, specify the magnitude of your indirect bankruptcy costs 26 General Market Data 27 Current riskfree rate in the currency ofnalysis = 28 Risk premium (for use in the CAPM) 29 Country Default spread (for cost of debt) 30 31 General Data 32 Which spread/ratio table would you like to use for your anlaysis? 33 Do you want to assume that existing debt is refinanced at the 'new rate? 34 Do you want the firm's current rating & cost of debt to be adjusted to the synthetic rating? 36 Yes Medium 1.31% 4.31% 0.00% 1 Yes (Yes or No) 35 No (Yes or No) 37 38 39 an Inputs Marginal tax rate by country Q UPS February 22, 2021 Financial Market ### #***### Current Beta for Stock = 1.06 debt: $6,015,213 Current Bond Rating = A 727290000 Summary of Inputs $2,948 Long Term Government Bond Ra 1.31% 4.31% Pre-tax cost of debt = 3.64% Income Statement Current EBITDA = Current Depreciation = Current Tax Rate = Current Capital Spending= Current Interest Expense RESULTS FROM ANALYSIS Current Optimal 0.00% #NUMI D/D+E) Ratio = Change #NUM! #NUM! f #NUM! #VALUE! Beta for the Stock = Cost of Equity = Rating on Debt After-tax cost of Debt = 1.06 5.88% 2.77% #NUM! #NUM! #NUM! #NUM WACC 5.88% Implied Growth Rate = 1.31% + Enterprise value ######### Value/share (Perpetual Growth) = $195.05 #NUMI #NUM! #NUMI #NUM! spreads in our analysis. Change them in the input sheet if necessary. Rating Coverage gt and It Spread AAA 8.5 100000 AA 6.5 8.499999 A+ 5.5 6,499999 Drop in EBITDA Current Interes 0.69% 0.00% Rating based up 0.85% 0.00% Interest rate bas 1.07% 0.00% Current rating fi UPS Feb-21 $11,422,000.00 $739.00 $1,670.00 $695,000.00 24.00% 3.64% Inputs Please enter the name of the company you are analyzing: Please enter the date that you are doing this analysis Financial Information Earnings before interest expenses, depreciation & amortization (EBITDA) 6 Depreciation and Amortization: 7 Capital Spending: 8 Interest expense on debt 9 Marginal tax rate to use for pre-tax cost of debt 10 Current Bond Rating on debt (if available) 11 Enter the current pre-tax cost of debt for your company 12 Market Information & Information on debt 13 Number of shares outstanding 14 Market price per share: 15 Beta of the stock: 16 Cash and marketable securities 17 Book value of debt: 18 Can you estimate the market value of the interest bearing debt? 19 so, enter the market value of interest bearing debt: 20 Do you want to estimate market value of debt? 21 yes, enter the weighted average maturity of outstanding debt? 22 Do you have any operating leases? 23 Indirect bankruptcy costs & ratings constraints (if any) 24 Do you want to incorporate indirect bankruptcy costs into your optimal? 25 yes, specify the magnitude of your indirect bankruptcy costs 26 General Market Data 7 727,290,000 $195.05 1.0600 $9.954.00 43,360.00 No S Yes 10.52 ? ask Yes Yes Medium inouts 727,290,000 $195.05 1.0600 ? $9.954.00 43,360.00 $ No Yes 10.52 7 ask Yes 12 Market Information & Information on debt 13 Number of shares outstanding 14 Market price per share 15 Beta of the stock 16 Cash and marketable securities = 17 Book value of debt: 18 Can you estimate the market value of the interest bearing debt? 19 so, enter the market value of "interest bearing" debt: 20 Do you want to estimate market value of debt? 21 \yes, enter the weighted average maturity of outstanding debt? 22 Do you have any operating leases? 23 Indirect bankruptcy costs & ratings constraints (if any) 24 Do you want to incorporate indirect bankruptcy costs into your optimal? 25 if yes, specify the magnitude of your indirect bankruptcy costs 26 General Market Data 27 Current riskfree rate in the currency ofnalysis = 28 Risk premium (for use in the CAPM) 29 Country Default spread (for cost of debt) 30 31 General Data 32 Which spread/ratio table would you like to use for your anlaysis? 33 Do you want to assume that existing debt is refinanced at the 'new rate? 34 Do you want the firm's current rating & cost of debt to be adjusted to the synthetic rating? 36 Yes Medium 1.31% 4.31% 0.00% 1 Yes (Yes or No) 35 No (Yes or No) 37 38 39 an Inputs Marginal tax rate by country Q UPS February 22, 2021 Financial Market ### #***### Current Beta for Stock = 1.06 debt: $6,015,213 Current Bond Rating = A 727290000 Summary of Inputs $2,948 Long Term Government Bond Ra 1.31% 4.31% Pre-tax cost of debt = 3.64% Income Statement Current EBITDA = Current Depreciation = Current Tax Rate = Current Capital Spending= Current Interest Expense RESULTS FROM ANALYSIS Current Optimal 0.00% #NUMI D/D+E) Ratio = Change #NUM! #NUM! f #NUM! #VALUE! Beta for the Stock = Cost of Equity = Rating on Debt After-tax cost of Debt = 1.06 5.88% 2.77% #NUM! #NUM! #NUM! #NUM WACC 5.88% Implied Growth Rate = 1.31% + Enterprise value ######### Value/share (Perpetual Growth) = $195.05 #NUMI #NUM! #NUMI #NUM! spreads in our analysis. Change them in the input sheet if necessary. Rating Coverage gt and It Spread AAA 8.5 100000 AA 6.5 8.499999 A+ 5.5 6,499999 Drop in EBITDA Current Interes 0.69% 0.00% Rating based up 0.85% 0.00% Interest rate bas 1.07% 0.00% Current rating fi