Question
In: Finance
Can you please show me how to do this on excel with formulas. I am having...
Can you please show me how to do this on excel with formulas. I am having a difficult time understanding how to incorporate the depreciation into the problem! Thank you
You are evaluating two different milling machines to replace your current aging machine. Machine A costs $248868, has a three-year life, and has pretax operating costs of $58935 per year. Machine B costs $406397, has a five-year life, and has pretax operating costs of $33004 per year. For both milling machines, use straight-line depreciation to zero over the project’s life and assume a salvage value of $40886. Your tax rate is 34 % and your discount rate is 10 %.
What is the EAC for Machine A?
Solutions
jeff jeffy answered 4 months agoRelated Solutions
Please show me how to do the following in excel. An additional "show formulas" would also...
Please show me how to do the following in excel. An additional
"show formulas" would also be helpful.
NOK Plastics is considering the acquisition of a new plastic
injection-molding machine to make a line of plastic fittings. The
cost of the machine and dies is $125,000. Shipping and installation
is another $8,000. NOK estimates that new project will require
$7,500 in inventory, and result in a $7,500 increase in accounts
receivable and a $5,000 increase in accounts payable. The latter...
Can someone do this in Excel and show me the formulas as well. The management of...
Can someone do this in Excel and show me the formulas as
well.
The management of Tri-County Air Taxi, Inc., is considering the
replacement of an old machine used in its helicopter repair
facility. It is fully depreciated but it can be used by the
corporation through 20x5. If management decides to replace the old
machine, James Transportation Company has offered to purchase it
for $69,000 on the replacement date. The old machine would have no
salvage value in 20x5....
PLEASE SHOW THE EXCEL INPUTS AND FORMULAS AS I AM VERY NEW TO THIS SUBJECT AND...
PLEASE SHOW THE EXCEL INPUTS AND FORMULAS AS I AM VERY NEW TO
THIS SUBJECT AND WANT TO LEARN EXCEL INPUTS.
Problem 7-18 Abandonment We are examining a new project. We
expect to sell 6,300 units per year at $57 net cash flow apiece for
the next 10 years. In other words, the annual operating cash flow
is projected to be $57 × 6,300 = $359,100. The relevant discount
rate is 12 percent, and the initial investment required is
$1,740,000....
Can you please show me the formulas you used in these problems? I keep using the...
Can you please show me the formulas you used in these problems?
I keep using the wrong ones.
In his last ride in a rocket sled in 1955, Col. Stapp was
accelerated to 632 miles per hour in 5.0 s, and then brought to a
stop with an acceleration of 46.2 g, the largest acceleration
voluntarily endured by a human.
a. How far did the sled move in the first phase, as it
accelerated to maximum speed?
b. How far...
Can you do in excel please and show the formulas Lunar Motivation Corporation Income Statement ($...
Can you do in excel please and show the
formulas
Lunar Motivation Corporation
Income Statement ($ in millions)
2019
Sales 8000
Cost
of
Goods -5600
SGA -1500
Interest -100
EBT 800
Taxes
(40%) -320
Net
income 480
Dividends -100
Retained
earnings 380
====
Lunar Motivation Corporation
Balance Sheet
2019 2019
Cash 10 Accounts
payable 300
Accounts
receivables 400 Notes
payable 300
Inventory 560 Current
liabilities 600
Short term
Investments 30 Long-term
debt 1000
Current
assets 1000 Common
stock 400
Net plant &
equip. 3000 Retained
earnings 2000
Total
assets 4000 Total
liab. & equity 4000
===== =====
You have forecasted Lunar Motivation Corporation (LMC) free cash
flow in 2020 to be...
Please give me the excel formulas for these so i can study them I don't need...
Please give me the excel formulas for these so
i can study them
I don't need calculations just the formula and the name of it.
maybe a brief sentence.
an investment pays 7710.02 (F51)
at the end of every year for 39 years (F52)
interest rate is 13.17% (F53)
what is this investment worth today?
----
you hope to earn a "ly" (yearly?) income of 701.38 (F59)
interest rate you will earn on yor investments is 14.39%
(F60)
You expect...
Hello! Can you show me how to this problem by hand? No Excel please! An organization...
Hello! Can you show me how to this problem by hand? No Excel
please!
An organization is considering the purchase of new machines to
automatically conduct some quality control tasks. The machines are
expected to save production cost which is given below as Annual
Income. The machines are expected to be part of the production
process for 5 years. The company has a minimum attractive rate of
return (MARR) of 5.4%. The following data is available for these
new machines:...
Can you do in excel please and show Formulas The Air Marshal Co. has recently completed...
Can you do in excel please and show Formulas
The Air Marshal Co. has recently completed a $10,000,000
two-year marketing study. Based on the results of this
study, Air Marshal has estimated that 800 units of its new security
electro-optical human scanning hardware, known as "Marshal Dillon,"
could be sold annually over the next 12 years, at a price of
$110,000 the first year with an estimated 2% annual rise from
inflation in years 2-6. The sales price is expected to
drop...
Can you do in excel please and show Formulas The Air Marshal Co. has recently completed...
Can you do in excel please and show Formulas
The Air Marshal Co. has recently completed a $10,000,000
two-year marketing study. Based on the results of this
study, Air Marshal has estimated that 800 units of its new security
electro-optical human scanning hardware, known as "Marshal Dillon,"
could be sold annually over the next 12 years, at a price of
$110,000 the first year with an estimated 2% annual rise from
inflation in years 2-6. The sales price is expected to
drop...
Can you do in excel and include the excel show formulas The Air Marshal Co. has...
Can you do in excel and include the excel show formulas
The Air Marshal Co. has recently completed a $10,000,000
two-year marketing study. Based on the results of this
study, Air Marshal has estimated that 800 units of its new security
electro-optical human scanning hardware, known as "Marshal Dillon,"
could be sold annually over the next 12 years, at a price of
$110,000 the first year with an estimated 2% annual rise from
inflation in years 2-6. The sales price is expected...
ADVERTISEMENT
ADVERTISEMENT
Latest Questions
- 4) Cost per equivalent unit of direct materials and conversion (4 marks) The cost per equivalent...
- We usually write numbers in decimal form (or base 10), meaning numbers are composed using 10...
- Consider a saturated solution of the salt MX3, which M is a metal cation with a...
- Energyshot is a new energy drink that is about to be introduced into the global market....
- Problem 1: During the month, EKM Enterprise purchased $100,000 in raw material on account, used $150,000...
- An electron is accelerated inside a parallel plate capacitor. The electron leaves the negative plate with...
- There is a region with a constant magnetic field 6.31T . The magnetic field is directed...
ADVERTISEMENT