Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

The complexity and uniqueness of the federal government makes it difficult to conduct a meaningful analysis of its financial condition. However, conducting a financial statement

The complexity and uniqueness of the federal government makes it difficult to conduct a meaningful analysis of its financial condition. However, conducting a financial statement analysis does provide a better understanding of the federal government. To assist in the financial statement analysis, use Illustration 172 and Illustration 173 along with the following excerpts from the 2013 Financial Report of the United States Government. (Hint: When using revenues or net costs, use the consolidated amounts, which are adjusted for intra-entity activity.)

image text in transcribed

image text in transcribed

Required
a.

To provide an indication of the governments financial capability answer the following: (Do not round intermediate calculations. Round percentage answers to 1 decimal place.)

(1) What percentage of total revenues comes from individual income taxes and withholdings?
Total revenue %?
(2)

What is the debt service as calculated by the ratio of principal and interest payments on debt held by the public to total revenue?

Debt service %?

b.

To provide an indication of the governments financial performance, answer the following: (Do not round intermediate calculations. Round percentage answer to 1 decimal place.)

(1) What is inter-period equity, as calculated by the ratio of revenue to net costs?
Inter-period equity %?

c.

To provide an indication of the governments financial position answer the following: (Do not round intermediate calculations. Round your answers to 2 decimal places.)

(1) What is the ratio of non-dedicated collections funds to total revenue?
Non dedicated collections funds ratio?
(2)

What is the quick ratio (use known current liabilities in the calculation)? Assume Accounts Payable is the only current liability.

Quick ratio?
(3)

What is the capital asset condition as calculated by the ratio of accumulated depreciation to the cost of depreciable capital assets? (Hint: Don't include non-depreciable assets in your calculation.)

Captial asset condition?
UNITED STATES GOVERNMENT Statements of Changes in Cash Balance from Unified Budget and Other Activities For the Years Ended September 30 (In billions of dollars) 2013 2012 (680.3) Unified budget deficit Adjustments for Noncash Outlays Included in the budget: Interest accrued by Treasury on debt held by the public TARP yearend re-estimates TARP Subsidy (income) Other Federal entity subsidy (income) (1,089.4) 242.7 240.1 32.3 (0.9) (11.9) (63.4) (10.8) (29.4) Subtotal 166.5 232.2 Items Affecting the Cash Balance Not Included in the budget: Net Transactions from financing activity: Borrowings from the public Repayment of debt held by the public Agency securities 8,145.4 (7,444.0) 0.7 7,766.9 (6,614.0) (0.4) Subtotal Transactions from monetary and other activity: Interest paid by Treasury on debt held by the public Net TARP direct loans and equity investments activity Net GSES-mortgage-backed securities activity Net loan receivable activity Allocations of special drawing rights Uninvested principal from the Thrift Savings Plan (TSP) G Fund 1,152.5 702.1 (248.7) 31.7 (234.3) 52.3 70.6 (153.7) (0.7) (125.6) (0.2) 119.9 34.7 Other (0.3) Subtotal (188.2) (266.1) Cash and other monetary assets: Increase in Cash and other monetary assets Balance, beginning of period 0.1 206.2 29.2 177.0 Balance, end of period 206.3 206.2 Property, Plant, and Equipment As of September 30, 2013 (In billions of dollars) Accumulated Depreciation/ Amortization Cost Net All All Defense All Others Defense Others Defense Others 269.8 983.6 46.6 10.8 11.0 0.6 0.4 1.0 Buildings, structures, and facilities Furniture, fixtures, and equipment Construction in progress Land Internal use software Assets under capital lease Leasehold improvements Other property, plant, and equipment 119.7 62.6 41.6 12.5 10.8 1.6 4.1 4.0 249.7 165.1 41.6 127.9 547.5 N/A N/A 8.0 0.4 0.2 130.0 102.5 N/A N/A 14.2 1.7 4.5 3.6 141.9 436.1 46.6 10.8 3.0 0.2 0.2 1.0 12.5 25.0 3.3 8.6 7.6 1,323.8 513.4 256.5 Subtotal 684.0 639.8 256.9 1,837.2 Total property, plant, and equipment, net 940.5 896.7 UNITED STATES GOVERNMENT Statements of Changes in Cash Balance from Unified Budget and Other Activities For the Years Ended September 30 (In billions of dollars) 2013 2012 (680.3) Unified budget deficit Adjustments for Noncash Outlays Included in the budget: Interest accrued by Treasury on debt held by the public TARP yearend re-estimates TARP Subsidy (income) Other Federal entity subsidy (income) (1,089.4) 242.7 240.1 32.3 (0.9) (11.9) (63.4) (10.8) (29.4) Subtotal 166.5 232.2 Items Affecting the Cash Balance Not Included in the budget: Net Transactions from financing activity: Borrowings from the public Repayment of debt held by the public Agency securities 8,145.4 (7,444.0) 0.7 7,766.9 (6,614.0) (0.4) Subtotal Transactions from monetary and other activity: Interest paid by Treasury on debt held by the public Net TARP direct loans and equity investments activity Net GSES-mortgage-backed securities activity Net loan receivable activity Allocations of special drawing rights Uninvested principal from the Thrift Savings Plan (TSP) G Fund 1,152.5 702.1 (248.7) 31.7 (234.3) 52.3 70.6 (153.7) (0.7) (125.6) (0.2) 119.9 34.7 Other (0.3) Subtotal (188.2) (266.1) Cash and other monetary assets: Increase in Cash and other monetary assets Balance, beginning of period 0.1 206.2 29.2 177.0 Balance, end of period 206.3 206.2 Property, Plant, and Equipment As of September 30, 2013 (In billions of dollars) Accumulated Depreciation/ Amortization Cost Net All All Defense All Others Defense Others Defense Others 269.8 983.6 46.6 10.8 11.0 0.6 0.4 1.0 Buildings, structures, and facilities Furniture, fixtures, and equipment Construction in progress Land Internal use software Assets under capital lease Leasehold improvements Other property, plant, and equipment 119.7 62.6 41.6 12.5 10.8 1.6 4.1 4.0 249.7 165.1 41.6 127.9 547.5 N/A N/A 8.0 0.4 0.2 130.0 102.5 N/A N/A 14.2 1.7 4.5 3.6 141.9 436.1 46.6 10.8 3.0 0.2 0.2 1.0 12.5 25.0 3.3 8.6 7.6 1,323.8 513.4 256.5 Subtotal 684.0 639.8 256.9 1,837.2 Total property, plant, and equipment, net 940.5 896.7

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access with AI-Powered Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Students also viewed these Finance questions