Penguin Network Warehouse, LLC (PNW, LLC) acquired the following assets last year: Industrial Refrigeration Equipment on...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
Penguin Network Warehouse, LLC ("PNW, LLC") acquired the following assets last year: Industrial Refrigeration Equipment on January 23 Network server computer equipment on May 4 Office furniture on June 12 Required: 1. Using the below MACRS depreciation table, leverage VLOOKUP formulas to calculate regular depreciation for each asset. 2. Sum the total depreciation for each year. (Hint: Use an IF formula with "Yes" and "No" to respond to the Fully Depreciated question.) Depreciation Rate for Recovery Period 3 5 33.33% 20.00% 44.45% 32.00% 19.20% 11.52% 11.52% 5.76% S 7 B 9 10 1 2 Year 1 23 24 25 Asset: 23 3 4 567 00 8 14.81% 7.41% Industrial Refrigeration Equipment Graded Worksheet + 7 14.29% 24.49% 17.49% 12.49% 8.93% 8.92% 8.93% 4.46% $ A1 4 25 26 27 28 29 30 31 32 33 34 35 35 37 38 39 0 1234557 18 24 25 Asset: 26 Class Life: 27 Basis: 36 40 Year 44 Asset: 45 Class Life: 46 Basis: 48 V BA Ev X fx Accessibility tab summary: Students please use the information below B C D E 1 2 P 3 4 5 T 6 7 Industrial Refrigeration Equipment Calibri 8 $1,434,214 Depreciaiton Rate 14.29%'$ 24.49% $ 17.49% 12.49% 8.93% 8.92% 8.93% 4.46% Total Fully Depreciated? 11 V $1,076,900 Depreciaiton Graded Worksheet + Calculation Mode: Automatic Workbook Statistics Amount Network Server Computer Equipment 192,034.57 329,106.14 *** O 2 3 4 5 -6 57 Asset: Class Life: Basis: 58 59 Year 50 61 62 63 Asset: 64 Class Life: 65 Basis: 66 67 1 2 3 s Network Server Computer Equipment 6 7 00 $1,076,900 Depreciaiton Rate Total Fully Depreciated? Office Furniture $1,002,237 Depreciaiton A Graded Worksheet Amount + = 6 B Asset: Class Life: Basis: 9 D 1 Year 2 3 Year 1 5 2 3 A Office Furniture 7 8 $1,002,237 Depreciaiton Rate Total Depreciation Total Fully Depreciated? 2 3 4 35 36 27 < > Graded Worksheet + Amount Amount 6 5 2 B 9 0 1 2 3 Total Depreciation Year 1 234 56700 8 Amount Penguin Network Warehouse, LLC ("PNW, LLC") acquired the following assets last year: Industrial Refrigeration Equipment on January 23 Network server computer equipment on May 4 Office furniture on June 12 Required: 1. Using the below MACRS depreciation table, leverage VLOOKUP formulas to calculate regular depreciation for each asset. 2. Sum the total depreciation for each year. (Hint: Use an IF formula with "Yes" and "No" to respond to the Fully Depreciated question.) Depreciation Rate for Recovery Period 3 5 33.33% 20.00% 44.45% 32.00% 19.20% 11.52% 11.52% 5.76% S 7 B 9 10 1 2 Year 1 23 24 25 Asset: 23 3 4 567 00 8 14.81% 7.41% Industrial Refrigeration Equipment Graded Worksheet + 7 14.29% 24.49% 17.49% 12.49% 8.93% 8.92% 8.93% 4.46% $ A1 4 25 26 27 28 29 30 31 32 33 34 35 35 37 38 39 0 1234557 18 24 25 Asset: 26 Class Life: 27 Basis: 36 40 Year 44 Asset: 45 Class Life: 46 Basis: 48 V BA Ev X fx Accessibility tab summary: Students please use the information below B C D E 1 2 P 3 4 5 T 6 7 Industrial Refrigeration Equipment Calibri 8 $1,434,214 Depreciaiton Rate 14.29%'$ 24.49% $ 17.49% 12.49% 8.93% 8.92% 8.93% 4.46% Total Fully Depreciated? 11 V $1,076,900 Depreciaiton Graded Worksheet + Calculation Mode: Automatic Workbook Statistics Amount Network Server Computer Equipment 192,034.57 329,106.14 *** O 2 3 4 5 -6 57 Asset: Class Life: Basis: 58 59 Year 50 61 62 63 Asset: 64 Class Life: 65 Basis: 66 67 1 2 3 s Network Server Computer Equipment 6 7 00 $1,076,900 Depreciaiton Rate Total Fully Depreciated? Office Furniture $1,002,237 Depreciaiton A Graded Worksheet Amount + = 6 B Asset: Class Life: Basis: 9 D 1 Year 2 3 Year 1 5 2 3 A Office Furniture 7 8 $1,002,237 Depreciaiton Rate Total Depreciation Total Fully Depreciated? 2 3 4 35 36 27 < > Graded Worksheet + Amount Amount 6 5 2 B 9 0 1 2 3 Total Depreciation Year 1 234 56700 8 Amount
Expert Answer:
Answer rating: 100% (QA)
Depreciation method Modified Accelerated Declining Balance Industrial Refrigeratio Equipment Year MA... View the full answer
Related Book For
Cornerstones of Financial and Managerial Accounting
ISBN: 978-0324787351
1st Edition
Authors: Rich Jones, Mowen, Hansen, Heitger
Posted Date:
Students also viewed these accounting questions
-
Do you agree with the statement that ''debits mean increase and credits mean decrease''? If not, what do debit and credit mean?
-
Do you agree with the statement that most people are capable of committing fraud? Do you believe that you are capable of committing fraud?
-
Do you agree with the statement that ''debits mean increase and credits mean decrease''? If not, what do debit and credit mean?
-
The following scatter plot indicates that 200 150 > 100 50 0 0 20 X 40 O a log x transform may be useful Oa y transform may be useful a x transform may be useful Ono transform is needed Oa 1/x...
-
Pre- planning is an essential step in making a sales presentation. Assume you are working for Apple (or any other marketer of desktop and laptop computers) and plan to make a sales presentation to...
-
Describe the four stages in the progression of a fire.
-
Enter the following items in the necessary debtors accounts only; do not write up other accounts. Then balance down each personal account at the end of the month. 19X6 May 1 33 " " " 9 4 10 18 20 24...
-
Suzy Vopat has owned and operated a proprietorship for several years. On January 1, she decides to terminate this business and become a partner in the firm of Vopat and Sigma. Vopats investment in...
-
Wildhorse Corp. currently has a cost of equity capital equal to 18 percent. Assume that the Modigliani and Miller Proposition 1 assumptions hold, with the exception of the assumption that there are...
-
? Dean and Ellen Price are married and have a manufacturing business. They bought a piece of business equipment (7-year personal property) on 4/1/2017 for $50,000. Use half-year convention to...
-
Quevo Sdn. Bhd. is undertaking a manufacturing project for the government. The startup costs for the project is expected to be RM1.1 million, and at the end of the tenure of the project 40% of the...
-
A 50 g horizontal metal bar, 14-cm-long, is free to slide up and down between two tall, vertical metal rods that are 14 cm apart. A 5.510-2 T magnetic field is directed perpendicular to the plane of...
-
You work for Microsoft. Your boss, Steve Ballmer, asks you to evaluate the firm's capital structure. Microsoft currently has a market value of $200 billion and no long-term debt outstanding. You...
-
A bond has a 11% coupon rate with semiannual coupons and matures in 14 years. The bond has a $1,000 face value and a current yield of 13.6%. Attempt 1/10 for 10 pts. Part 1 What is the bond's price?...
-
Image transcription text 28. Name the sensors and other engine components below. WU 10 2 5 C 6 5 109 7 9 10 28. Name the sensors and other engine components below. 10 N 8 6 5 7 9 S 8 10 2 3
-
2) The instantaneous positions and velocities of three particles are shown in the figure below. Find: (a) the position of the CM; (b) the velocity of the CM; (c) the position of the CM 3.00 s later...
-
. For this problem, you will want to use Python (and NumPy). Consider a function f(x) which is continuous on the interval [a, b). Assume that m < f(x) < M for every z ( [a, b] for some constan...
-
-4 1 9. Let A = Find A-1, (A") and verify that (A")= (A-1)".
-
Are dividends in arrears reported among the liabilities of the dividend-paying firm? If not, how are they reported, and why?
-
Ethical behavior is essential to the conduct of business activity. Consider each of the following business behaviors: 1. A manager prepares financial statements that grossly overstate the performance...
-
What are components of cost of goods available for sale and cost of goods sold?
-
Try-Star Leasing Company enters into a contract with LLX Corporation for equipment under lease for a threeyear period. The equipment will have no residual value when the lease term ends and has an...
-
A lessor entered into a 5-year lease appropriately classified as a sales-type lease. The cost of the underlying asset was \(\$ 40,000\) and the fair value of the asset was \(\$ 50,000\). The lease...
-
Using the information from Exercise 17-72, complete the following requirements from the lessor's perspective. Required a. Determine the classification of the lease to Try-Star Leasing Company. b....
Study smarter with the SolutionInn App