1answer.
Ask question
Login Signup
Ask question
All categories
  • English
  • Mathematics
  • Social Studies
  • Business
  • History
  • Health
  • Geography
  • Biology
  • Physics
  • Chemistry
  • Computers and Technology
  • Arts
  • World Languages
  • Spanish
  • French
  • German
  • Advanced Placement (AP)
  • SAT
  • Medicine
  • Law
  • Engineering
solong [7]
3 years ago
5

You are in the process of getting a new car but are not sure if you should buy or lease. The price of the car you want is $18,00

0, but you do not want to spend more than $250 a month on car payments. If you lease the car, the terms of the lease will be 48 months at an annual interest rate of 5%. The residual value of the car will be set at $9,000. If you buy the car, your bank will offer you a 7-year loan at an annual interest rate of 6%. You are not required to make a down payment with either the lease or loan options, and payments are made at the end of the month for both options.
Should you lease or buy the car given your budget limit of $250 a month? Create a new workbook and design a worksheet that shows the difference between leasing and buying the car in terms of monthly payments. Use proper formatting so your worksheet is easy to read. Remember to use column and row headings, add a title to your worksheet, and rename the worksheet tab with an appropriate label. Include your name in the file name of the workbook.
Business
1 answer:
Mnenie [13.5K]3 years ago
8 0

Answer:

You should buy the car.

Explanation:

Note: See the attached excel file for the worksheet that shows calculations of the present values of the Lease and Buy Options.

In the attached excel file, we have:

Net present value of Lease Option = $3,654.01

Total present value of Buy Option = $4,135.47

Difference = Total present value of Buy Option - Present value of Lease Option = $481.46

The Difference above shows that the total present value of Buy Option is greater than the net present value of Lease Option by $481.46.

Since the total present value of Buy Option of $4,135.47 is greater than the net present value of Lease Option of $3,654.01, you should buy the car.

Download xlsx
You might be interested in
Plant-wide, department, and activity-cost rates. Acclaim Inc. makes two styles of trophies, basic and deluxe, and operates at ca
Elena L [17]

Answer:

Acclaim Inc.

                                         Basic Trophies     Deluxe Trophies

Budgeted unit cost:

a. using single-plant o/h rate   $17.60                  $28.80

b. using departmental rates    $17.42                  $29.16

c. using ABC                            $18.26                  $27.48

d. They show different costs because the overhead rates are based on different parameters.

I recommend ABC system.  It is more fair because the overhead rates are based on product line's activity usage instead of an arbitrary figure.

Explanation:

a) Data and Calculations:

                                         Basic Trophies     Deluxe Trophies        Total

Budgeted production               10,000                   5,000              15,000

Batches                                         200                        50                   250

                                         Basic Trophies     Deluxe Trophies        Total

Forming Department            $60,000              $35,000           $95,000

Direct manufacturing labor $30,000              $20,000           $50,000

Assembly

Direct materials                    $5,000                $10,000            $15,000

Direct manufacturing labor  15,000                  25,000             40,000

Total direct costs              $110,000                $90,000        $200,000

Overhead costs                  66,000                   54,000           120,000

Total production costs    $176,000               $144,000        $320,000

Budgeted production          10,000                    5,000

Budget unit costs               $17.60                  $28.80

Overhead rate

Total overhead/total direct costs = $120,000/$200,000 = $0.60

                                                             Basic        Deluxe        Total

                                                         Trophies    Trophies

Forming department:

Overhead costs Setup $48,000

General overhead        $32,000

Total overhead costs   $80,000

Overhead rate = $80,000/$145,000 = $552

 Assembly department

General overhead         $40,000/$55,000 = $0.727

                                         Basic Trophies     Deluxe Trophies        Total

Forming Department            $60,000              $35,000           $95,000

Direct manufacturing labor $30,000              $20,000           $50,000

Total direct costs                 $90,000              $55,000          $145,000

Overhead costs                     49,680                 30,360              80,040

Total departmental costs  $139,680               $85,360         $225,040

Assembly

Direct materials                    $5,000                $10,000            $15,000

Direct manufacturing labor  15,000                  25,000             40,000

Total direct costs               $20,000                $35,000          $55,000

Overhead costs                    14,540                   25,445            39,985

Total departmental costs  $34,540                $60,445          $94,985

Total production costs     $174,220               $145,805       $320,025

Budgeted production          10,000                    5,000

Budget unit costs               $17.42                  $29.16

                                         Basic Trophies     Deluxe Trophies        Total

Forming Department            $60,000              $35,000           $95,000

Direct manufacturing labor $30,000              $20,000           $50,000

Assembly

Direct materials                    $5,000                $10,000            $15,000

Direct manufacturing labor  15,000                  25,000             40,000

Total overhead allocated  $72,600                 $47,400        $120,000

Total production costs    $182,600                $137,400       $320,000

Budgeted production          10,000                    5,000

Budget unit costs                $18.26                  $27.48

Overhead costs allocation:

                                                            Basic        Deluxe        Total

                                                         Trophies    Trophies

Forming department:

Overhead costs Setup $48,000/250  $38,400  $9,600     $48,000

General overhead  $32,000/$50,000   19,200   12,800       32,000

Assembly department

General overhead $40,000/$40,000   15,000   25,000      40,000

Total overhead allocated                    $72,600 $47,400   $120,000

6 0
3 years ago
Productivity measurement is complicated by
CaHeK987 [17]
Productivity measurement is complicated by the fact the precise units of measure are often unavailable. When you are managing productivity it can vary based on each task or the person completing the tasks. Because of this, it makes it complicated for management to measure productivity as there could be no units or no comparable units to measure. Productivity is better reflected on the outcome of what they do complete versus what they do not. 
3 0
3 years ago
Maurice can drive or fly from Jacksonville, Florida to Atlanda, Georgia, for a one-day business trip. If he drives, he will be a
ArbitrLikvidat [17]

Answer:

c. $150.

Explanation:

the extra amount of hours Maurice can work taking a flight will be of 5 hours

(8 hours taking a plane against 3 hours if driving)

As the income per hour is 30 dollar it can generate;

5 hours x $30 per hour = $150

Maurice will only travel by plane if it generates the same or more income than the driving thus, a differencial price of less than 150 dollars will provide Maurice with a net gain. Also we should consider that if Maurice drives his car it is taking a depreication hit per mile while driving that is being ignoer to keep the assignment simple. But considering that the amount of differential income could be higher than $150

8 0
3 years ago
2. Simplify the following<br><br><br><img src="https://tex.z-dn.net/?f=%20%28%5Cfrac%7B1%7D%7Ba%7D%20%20-%20%20%5Cfrac%7B1%7D%7B
MAXImum [283]
1/a - 1/b -1
Just remove the parentheses
6 0
3 years ago
Mikail's perfectly competitive camera memory card–producing factory is making positive economic profits. If the price of memory
irina1246 [14]

Answer:

B. $6000

Explanation:

Given that

Price = $9

Average total cost (ATC) = $7

Output (Q) = 3000

Two methods can be used in calculating profit in this case.

The first method is

Profit = (price - ATC) × Q

= (9 - 7) × 3000

= 2 × 3000

= $ 6000

The second method is

Profit = Total revenue (TR) - Total Cost (TC)

Where TR = Price × Q = 9 × 3000 = $27000

TC = ATC × Q = 7 × 3000 = $ 21000

Therefore,

Profit = 27000 - 21000

= $6000

Any method used will result to the same answer.

NOTE THAT,

ATC = Total cost / Q.

So change of formula was used to obtain Total cost from this formula.

4 0
3 years ago
Other questions:
  • Jack has a photography studio. He provides high-resolution images on a disc to all his clients. What step should Jack take befor
    7·1 answer
  • Product innovation refers to efforts to create designs and applications of technology to develop new products, while __________
    10·1 answer
  • If the total cost of producing 4 units is $150 and the marginal cost of producing the fifth unit is $20, then the total cost of
    14·1 answer
  • Compare the two organizations you selected in terms of the public services they provide. How are they alike, and how are they di
    14·1 answer
  • At Bargain Electronics, it costs $29 per unit ($20 variable and $9 fixed) to make an MP3 player at full capacity that normally s
    11·1 answer
  • Which of the following accurately describes the process of currency
    10·1 answer
  • Croissants Corporation and Donuts Company transfer their assets to Edibles Inc., which manages the assets and distributes the pr
    10·1 answer
  • After getting her degree in marketing and working for 5 years for a large department store, Sally started her own specialty shop
    6·1 answer
  • Jim and Evan enter into a real estate contract. The contract allows Evan to get a mortgage at 5% interest. But after due diligen
    8·1 answer
  • Blank______ levels of withdrawal behavior are closely correlated with a Blank______ degree of organizational commitment.
    14·1 answer
Add answer
Login
Not registered? Fast signup
Signup
Login Signup
Ask question!