In today’s fast-paced academic environment, students often find themselves juggling multiple responsibilities, from attending classes and working part-time jobs to participating in extracurricular activities. The demands of modern education can be overwhelming, leaving students in search of effective solutions to manage their academic workload efficiently. One such solution is the use of Nursingpapertutors.com academic writing website. Nursingpapertutors.com academic writing website employ a cadre of experienced and knowledgeable writers who are well-versed in various academic subjects and writing styles. Nursingpapertutors.com professionals bring a wealth of expertise to the table, enabling them to produce well-researched and well-structured papers that meet the academic standards and expectations of students. Their familiarity with diverse subjects ensures that students can receive assistance across a wide spectrum of disciplines, from mathematics to literature, and from nursing to engineering.
Note: this is worth ONLY 50pts of my final grade!
Assignment 3: Excel Problems
At the end of each module, you will apply the module’s concepts by completing comprehensive assignments from the textbook.
Complete problems P9-28A (p. 517), P10-A-9B (p. 586), and P11-29A (p. 631) in your textbook.
Present your analysis of the assigned problems in Excel format. Enter non-numerical responses in the same worksheet using textboxes.
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.
One of the significant challenges students face is time management. The demands of coursework, assignments, and exams can create immense pressure, leading to stress and a potential drop in academic performance. Nursingpapertutors.com academic writing website can be a valuable resource for students seeking to balance their responsibilities effectively. By outsourcing some of their academic tasks, students can free up time to focus on studying, participating in meaningful extracurricular activities, or even addressing personal obligations. This improved time management can alleviate the stress associated with academic overload. The ultimate goal of education is to enhance one’s knowledge and skills. Nursingpapertutors.com academic writing websites can play a vital role in achieving this goal by providing students with well-crafted papers that serve as models for their own work. These papers can offer valuable insights into effective research, organization, and writing, thereby empowering students to improve their academic performance over time.