Question: Using the US Budget Spreadsheet, update the fields. What happens to Federal Debt if we lower interest rates to 1% from 2019 forward? AutoSave Off

Using the US Budget Spreadsheet, update the fields. What happens to Federal Debt if we lower interest rates to 1% from 2019 forward?

Using the US Budget Spreadsheet, update the fields. What happens to Federal

AutoSave Off be US_BUDGET Search Margaret Grant-Wooden MG File Home Insert Draw Page Layout Formulas Data Review View Help Share Comments SUM X fx =Q10-Q25-261-263 O J K L M N S T U V w Q 2024 R 2025 2017 2018 2019 2020 2021 2022 2026 2027 2029 2030 111.65 41.72 27.30 115.00 42.97 28.11 43.92 118.45 44.26 28.96 122.01 45.58 29.83 46.60 o 997.09 154.55 57.74 37.78 59.03 42.64 45.24 2028 145.68 54.43 35.61 55.64 1,190.58 877.04 239.08 2003 20.02 133.30 42.80 38.70 51.80 835.00 599.00 179.30 12.90 43.80 0720 397.30 po 304.90 4.50 41.90 50.50 40.20 32.60 7.60 912.48 672.18 183.24 15.35 41.72 968.05 713.11 194.40 16.28 734.51 939.85 692.34 188.73 15.81 42.97 ce 375.03 137.32 51.30 33.57 52.44 1,122.23 826.69 225.36 18.87 51.30 447.80 339.62 22.04 47.50 60.68 150.05 56.06 36.68 57.31 1,226.29 903.35 WS 246.26 20.63 56.06 108.40 40.50 26.50 41.40 or ) 885.90 652.60 177.90 w 14.90 40.50 ra 353.50 268.10 37.50 47.90 41.50 34.30 7.20 91.80 52.40 44.26 200.23 16.77 45.58 202 397.87 40 301.75 42.21 53.91 54.43 141.44 52.84 34.58 54.02 1,155.90 851.49 232.12 19.44 52.84 2 461.24 349.81 48.93 62.50 54.15 44.75 9.39 119.84 284.43 475.07 360.30 50.40 64.37 364.11 276.14 38.63 49.34 42.75 35.33 7.42 94.60 489.33 371.11 51.91 66.30 57.45 47.48 9.97 39.78 50.82 44.03 36.39 7.64 97.44 P 2023 125.67 46.95 30.72 47.99 1,027.00 756.54 206.23 17.27 46.95 409.80 2.00 310.80 43.47 55.53 48.11 39.76 8.35 106.47 60.75 21.56 27.24 11.94 133.08 21.79 38.84 (2.20) 12.40 7.65 13.68 26.78 9.39 4.75 1,910.88 5,336.68 1,029.54 29 DISCRETIONARY SPENDING (These can be change 2016 30 Education 138.80 31 Pre primary thru secondary education 46.00 32 Tertiary education 40.90 33 Education not definable by level 51.90 34 Defense 822.70 35 Military defense 592.00 36 Veterans 178.30 37 1900 Foreign Military aid 12.80 38 Foreign economic aid 39.60 39 Welfare 19 20 402.20 40 Family and children 307.20 41 Unemployment 43.70 42 Housing 51.30 soto 43 Protection 39.70 44 Police services 32.10 45 Prisons 7.60 46 Transportation 107.20 47 General Government 49.50 48 Executive and legislative organs, financ 19.30 49 Law courts 21.50 General services 8.70 51 Other Spending 123.70 52 Basic research 18.60 53 Agriculture, forestry, fishing and hunti 32.90 54 Fuel and energy (4.10) 55 Economic affairs 17.50 56 Pollution abatement 9.50 57 Protection of biodiversity and landscape 14.80 58 Community development 20.70 59 Water supply 8.10 60 Recreational and sporting services 5.70 61 Total Discretionary Spending 1,683.80 62 Total Spending 3,976.70 63 Interest (Cost of Financing NATIONAL DEBT) 687.71 64 65 Federal Debt/Surplus (Parenthesis Represents (598.21) 66 67 Gross Public Debt or Surplus 21,025.41 68 69 US_BUDGET Budget No Color Not Locked 1,263.08 930.45 253.64 21.24 57.74 20 504.01 382.25 53.47 68.29 59.17 48.90 10.27 130.95 386.28 292.96 40.98 52.34 ra 45.35 37.48 7.87 100.36 57.26 20.32 25.68 11.26 125.45 20.54 36.61 108.10 133.32 49.81 32.59 50.92 1,089.55 802.62 218.79 18.33 49.81 2 434.76 329.73 2.1 46.12 58.91 51.04 42.18 8.86 112.96 64.45 22.88 28.90 12.67 141.19 23.12 41.20 (2.34) 13.16 8.12 14.51 28.41 9.96 5.04 2,027.26 129.44 48.36 31.64 49.43 1,057.81 779.24 212.42 17.79 48.36 422.10 320.13 US 44.78 57.20 49.55 40.96 8.60 109.67 62.57 22.21 28.06 12.30 137.08 22.45 40.00 (2.27) 12.78 7.88 14.09 27.58 9.67 4.90 1,968.21 5,720.21 1,091.131 46.71 38.60 8.10 103.37 58.98 20.931 26.45 11.59 129.21 52.80 19.40 23.00 10.40 18.60 23.50 10.30 68.37 24.27 30.66 13.44 53.97 19.16 24.21 10.61 118.24 19.36 34.51 (1.96) 11.02 50 55.59 19.73 24.93 10.93 121.79 19.94 35.54 (2.02) 11.35 114.80 55.77 46.10 9.68 123.43 70.42 25.00 31.58 13.84 154.28 25.27 45.02 (2.55) 18.80 33.50 (1.90) 10.70 52.57 43.45 9.12 116.35 66.38 23.56 29.77 13.05 145.43 23.82 42.44 (2.41) ) 13.55 8.36 14.95 29.26 10.26 5.19 2,088.07 6,449.27 1,247.20 (2.08) 123.80 18.30 33.50 1.70 15.50 7.90 15.50 18.90 7.60 4.90 1,690.50 11.69 127.13 72.53 25.75 32.53 14.26 158.91 26.02 46.37 (2.63) 14.81 9.14 16.33 31.98 11.21 5.68 2,281.69 7,272.69 1,609.52 6.60 6.80 74.71 26.52 33.51 14.69 163.68 26.80 47.76 (2.71) 15.26 9.41 16.82 32.94 11.55 5.85 2,350.15 8,055.95 1,829.08 7.00 7.21 14.38 8.87 15.86 11.80 12.15 149.79 24.53 43.71 (2.48) 13.96 8.61 15.40 30.14 10.57 5.35 2,150.72 6,364.72 1,337.89 21.16 37.70 (2.14) 12.04 7.43 13.28 26.00 9.12 4.61 1,855.23 5,050.63 915.49 23.10 23.79 12.52 24.51 8.59 4.35 1,748.73 8.34 4.22 12.89 25.24 8.85 4.48 1,801.19 4,636.39 819.68 8.10 4.10 1,648.30 3,830.70 743.78 31.04 10.89 5.51 2,215.24 6,730.74 1,508.90 1,697.80 4,008.80 663.46 3,997.80 721.56 4,311.83 736.51 6,167.36 1,162.80 (482.36) (607.48) (546.57) (757.63) (993.74) (1,325.29) (1,539.76) =Q10-Q25-261-263 (2,267.36) (2,056.33) (2,367.51) (2,775.20) (3,533.73) 21,507.77 22,115.25 22,661.82 23,419.45 24,413.19 25,738.48 27,278.24 29,070.06 31,179.92 33,447.27 35,503.60 37,871.12 40,646.32 44,180.05 + Edit El + 100% AutoSave Off be US_BUDGET Search Margaret Grant-Wooden MG File Home Insert Draw Page Layout Formulas Data Review View Help Share Comments SUM X fx =Q10-Q25-261-263 O J K L M N S T U V w Q 2024 R 2025 2017 2018 2019 2020 2021 2022 2026 2027 2029 2030 111.65 41.72 27.30 115.00 42.97 28.11 43.92 118.45 44.26 28.96 122.01 45.58 29.83 46.60 o 997.09 154.55 57.74 37.78 59.03 42.64 45.24 2028 145.68 54.43 35.61 55.64 1,190.58 877.04 239.08 2003 20.02 133.30 42.80 38.70 51.80 835.00 599.00 179.30 12.90 43.80 0720 397.30 po 304.90 4.50 41.90 50.50 40.20 32.60 7.60 912.48 672.18 183.24 15.35 41.72 968.05 713.11 194.40 16.28 734.51 939.85 692.34 188.73 15.81 42.97 ce 375.03 137.32 51.30 33.57 52.44 1,122.23 826.69 225.36 18.87 51.30 447.80 339.62 22.04 47.50 60.68 150.05 56.06 36.68 57.31 1,226.29 903.35 WS 246.26 20.63 56.06 108.40 40.50 26.50 41.40 or ) 885.90 652.60 177.90 w 14.90 40.50 ra 353.50 268.10 37.50 47.90 41.50 34.30 7.20 91.80 52.40 44.26 200.23 16.77 45.58 202 397.87 40 301.75 42.21 53.91 54.43 141.44 52.84 34.58 54.02 1,155.90 851.49 232.12 19.44 52.84 2 461.24 349.81 48.93 62.50 54.15 44.75 9.39 119.84 284.43 475.07 360.30 50.40 64.37 364.11 276.14 38.63 49.34 42.75 35.33 7.42 94.60 489.33 371.11 51.91 66.30 57.45 47.48 9.97 39.78 50.82 44.03 36.39 7.64 97.44 P 2023 125.67 46.95 30.72 47.99 1,027.00 756.54 206.23 17.27 46.95 409.80 2.00 310.80 43.47 55.53 48.11 39.76 8.35 106.47 60.75 21.56 27.24 11.94 133.08 21.79 38.84 (2.20) 12.40 7.65 13.68 26.78 9.39 4.75 1,910.88 5,336.68 1,029.54 29 DISCRETIONARY SPENDING (These can be change 2016 30 Education 138.80 31 Pre primary thru secondary education 46.00 32 Tertiary education 40.90 33 Education not definable by level 51.90 34 Defense 822.70 35 Military defense 592.00 36 Veterans 178.30 37 1900 Foreign Military aid 12.80 38 Foreign economic aid 39.60 39 Welfare 19 20 402.20 40 Family and children 307.20 41 Unemployment 43.70 42 Housing 51.30 soto 43 Protection 39.70 44 Police services 32.10 45 Prisons 7.60 46 Transportation 107.20 47 General Government 49.50 48 Executive and legislative organs, financ 19.30 49 Law courts 21.50 General services 8.70 51 Other Spending 123.70 52 Basic research 18.60 53 Agriculture, forestry, fishing and hunti 32.90 54 Fuel and energy (4.10) 55 Economic affairs 17.50 56 Pollution abatement 9.50 57 Protection of biodiversity and landscape 14.80 58 Community development 20.70 59 Water supply 8.10 60 Recreational and sporting services 5.70 61 Total Discretionary Spending 1,683.80 62 Total Spending 3,976.70 63 Interest (Cost of Financing NATIONAL DEBT) 687.71 64 65 Federal Debt/Surplus (Parenthesis Represents (598.21) 66 67 Gross Public Debt or Surplus 21,025.41 68 69 US_BUDGET Budget No Color Not Locked 1,263.08 930.45 253.64 21.24 57.74 20 504.01 382.25 53.47 68.29 59.17 48.90 10.27 130.95 386.28 292.96 40.98 52.34 ra 45.35 37.48 7.87 100.36 57.26 20.32 25.68 11.26 125.45 20.54 36.61 108.10 133.32 49.81 32.59 50.92 1,089.55 802.62 218.79 18.33 49.81 2 434.76 329.73 2.1 46.12 58.91 51.04 42.18 8.86 112.96 64.45 22.88 28.90 12.67 141.19 23.12 41.20 (2.34) 13.16 8.12 14.51 28.41 9.96 5.04 2,027.26 129.44 48.36 31.64 49.43 1,057.81 779.24 212.42 17.79 48.36 422.10 320.13 US 44.78 57.20 49.55 40.96 8.60 109.67 62.57 22.21 28.06 12.30 137.08 22.45 40.00 (2.27) 12.78 7.88 14.09 27.58 9.67 4.90 1,968.21 5,720.21 1,091.131 46.71 38.60 8.10 103.37 58.98 20.931 26.45 11.59 129.21 52.80 19.40 23.00 10.40 18.60 23.50 10.30 68.37 24.27 30.66 13.44 53.97 19.16 24.21 10.61 118.24 19.36 34.51 (1.96) 11.02 50 55.59 19.73 24.93 10.93 121.79 19.94 35.54 (2.02) 11.35 114.80 55.77 46.10 9.68 123.43 70.42 25.00 31.58 13.84 154.28 25.27 45.02 (2.55) 18.80 33.50 (1.90) 10.70 52.57 43.45 9.12 116.35 66.38 23.56 29.77 13.05 145.43 23.82 42.44 (2.41) ) 13.55 8.36 14.95 29.26 10.26 5.19 2,088.07 6,449.27 1,247.20 (2.08) 123.80 18.30 33.50 1.70 15.50 7.90 15.50 18.90 7.60 4.90 1,690.50 11.69 127.13 72.53 25.75 32.53 14.26 158.91 26.02 46.37 (2.63) 14.81 9.14 16.33 31.98 11.21 5.68 2,281.69 7,272.69 1,609.52 6.60 6.80 74.71 26.52 33.51 14.69 163.68 26.80 47.76 (2.71) 15.26 9.41 16.82 32.94 11.55 5.85 2,350.15 8,055.95 1,829.08 7.00 7.21 14.38 8.87 15.86 11.80 12.15 149.79 24.53 43.71 (2.48) 13.96 8.61 15.40 30.14 10.57 5.35 2,150.72 6,364.72 1,337.89 21.16 37.70 (2.14) 12.04 7.43 13.28 26.00 9.12 4.61 1,855.23 5,050.63 915.49 23.10 23.79 12.52 24.51 8.59 4.35 1,748.73 8.34 4.22 12.89 25.24 8.85 4.48 1,801.19 4,636.39 819.68 8.10 4.10 1,648.30 3,830.70 743.78 31.04 10.89 5.51 2,215.24 6,730.74 1,508.90 1,697.80 4,008.80 663.46 3,997.80 721.56 4,311.83 736.51 6,167.36 1,162.80 (482.36) (607.48) (546.57) (757.63) (993.74) (1,325.29) (1,539.76) =Q10-Q25-261-263 (2,267.36) (2,056.33) (2,367.51) (2,775.20) (3,533.73) 21,507.77 22,115.25 22,661.82 23,419.45 24,413.19 25,738.48 27,278.24 29,070.06 31,179.92 33,447.27 35,503.60 37,871.12 40,646.32 44,180.05 + Edit El + 100%

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related Finance Questions!

Case Analysis 1. Compute the yield to maturity of Land'o'Toys' bonds before the purchase announcement and use it to determine the likely current bond rating. (Compare YTM to the table on p. 269)....

Part 1: Recent Economic and Financial Developments Monetary Policy Report submitted to the Congress on February 7, 2020, pursuant to section 2B of the Federal Reserve Act Domestic Developments The...

Bloomberg CASEO Businessweek STUDIES 4 Weighted Average Cost of Capital Analyze how the theoretical concepts This lesson explores how several companies and industries are of weighted average cost of...

Hello tutor Please find the attached instruction file and use the template for solving this question. If you have any question about the problem please contact me. Thanks Your Course Project...

FILE TOOLS VIEW 6401819_1_writing-case--4 - Word (Product Activation Failed) Financing Early Operations Musk's first entrepreneurial venture was to join up with his brother, Kimbal, and establish...

MGMT4308 DR. HUANG Knowledge Base for General Environmental Analysis1 The general environment is composed of factors that can have dramatic effects on firm strategy. We divide the general environment...

ITEM #1 LEARNING FROM THE HEADLINES True to the Learning from the Headlines approach of this course, watch the Part Three Intro Video after you read the short article the video highlights. Notice...

3 COLLEGE ALGEBRA - TRIGONOMETRY Business and Finance (MAT115) This course will start with a review of basic algebra (factoring, solving linear equations, and equalities, etc.) and proceed to a study...

As if dealing with economic cycles, fuel price volatility, organized labor, changing customer demographics, and increased competition was not enough... Delta CEO Ed Bastian assumed the role of Deltas...

This need to be answer form the article which is uploaded with this question. 1. Draw a supply and demand graph to illustrate the changes described above. Be sure to label your graph and clearly...

Review the math in Table 16 3 Discounted Cash Flow to Estimate Price and give your opinion on which part of the assumptions price increases or sales price is more subject to poor thinking

In Problem 14.6 on page 583, you used radio advertising and newspaper advertising to predict sales (stored in Advertise). Develop a regression model to predict sales that includes radio advertising,...

23. What are the five basic assumptions that underlie the financial accounting structure?

2023 1040 form 1.Phillip and Claire are married and file a joint return. Phillip is self-employed as a real estate agent, and Claire is a flight attendant. Phillip and Claire have three dependent...