# Excel in Practice for Accounting

Oct 17th, 2014
Anonymous
Category:
Accounting
Price: \$15 USD

Question description

P9-28A (p.517) :Capitalized asset cost and first year depreciaton, and identifying depreciation results that meet management objectives

* On January 9, 2010, Swifty Delivery Service purhcased a truck at a cost of \$67,000. Before placing the truck in service, Swifty spent \$2,200 painting it, \$500 replacing tires, and \$5,000 overhauling the engine. The truck should remain in service for 6 years and have a residulal value of \$14,700. The trucks annual mileage is expected to be 15,000 miles in each of the first 4 years and 10,000 miles in each of the next 2 years-80,000 miles in total. In deciding which depreciation method to use, Jerry Speers, the general manager, requests a depreciation schedule for each of the depreciation methods (straight-line, units-of production, and double-declining blanace).

REQUIREMENTS:

1. Prepare a depreciation schedule for each depreciation method, showing asset cost, depreciation expense, accumulated depreciaiton, and asset book value.

2. Swifty prepares fianancial statements using the depreciation method that reports the highest net income in the early years of asset use. For income-tax purposes, the company uses the depreciation method that minimizes income taxes in the early years. Consider the first year that Swifty uses the truck. Identify the deprecitiaon methods that meet the general managers objectives, assuming the income tax authorities permit the use of any of the methods.

P10A-9B: p.586 -Calculating present value

Axel needs new manufacturing equipment. Two companies can provide similar equipment but unde different payment plans:

Plan A: MRE offers to let Axel pay \$55,000 each year for five years. The payments include interest at 12% per year.

Plan B: Westernhome will let Axel make a single payment of \$425,000 at the end of five years. This payment includes both principal and interest at 12%.

REQUIREMENTS:

1. calculate the present value of PLAN A.

2. calculate the present value of PLAN B.

3. Axel will purchase the equipment that costs the least, as measured by present value. Which equipment should Axel select? Why? (challenge)

P11-29A p. 631: Analyzing the stockeholders equity section of the balance sheet

The balance sheet of Ballcraft, Inc, reported the following:

Preferred stock, \$6 par, 6%

5,000 shares authorized and issued...................................... \$ 30,000

Common stock, \$4.00 par value, 45,000 shares authorized;

10,000 shares issued.............................................................  40,000

Additional paid-in capital-common..................................................  219,000

Total paid-in capital.......................................................................  289,000

Retained earnings.........................................................................  90,000

Total stockholders equity..............................................................\$  379,000

Preferred dividends are in arrears for two years, including the current year. On the balance sheet date, the market value of the Ballcraft common stock was \$31 per share.

Requirements

1. Is the preferred stock cumulatie or noncumulative? How can you tell?

2. What is the total paid-in capital of the company?

3. What was the total market value of the common stock?

4. Compute the book value per share of the common stock.

Use the attached excel spreadsheet for the answers.

Attachments:

School: UCLA

Studypool has helped 1,244,100 students

Review from student
Anonymous
" Thanks, good work "

Type your question here (or upload an image)

1824 tutors are online

Brown University

1271 Tutors

California Institute of Technology

2131 Tutors

Carnegie Mellon University

982 Tutors

Columbia University

1256 Tutors

Dartmouth University

2113 Tutors

Emory University

2279 Tutors

Harvard University

599 Tutors

Massachusetts Institute of Technology

2319 Tutors

New York University

1645 Tutors

Notre Dam University

1911 Tutors

Oklahoma University

2122 Tutors

Pennsylvania State University

932 Tutors

Princeton University

1211 Tutors

Stanford University

983 Tutors

University of California

1282 Tutors

Oxford University

123 Tutors

Yale University

2325 Tutors