Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

please solve this Q( annual worth by excel) and use Excel financial functions i need solve like second picture first picture is my question second

please solve this Q( annual worth by excel)
and use Excel financial functions
i need solve like second picture
first picture is my question
second picture just An example of what I want
image text in transcribed
image text in transcribed
A company wants to buy a machine through installment there are two similar machine, Which alternative is economically better using X or y using the AW(annual worth) and I need cash flow diagrame for two machine MARR/per year is i=10% Machine type X Y First installment payment B Last installment payment 32,000 $ 40,000 $ Maintenance cost/per year 6000 $ 2000 $ Annual payment 18,000$ 15,000$ Fule for 50,000 KM/per year 6050 $ 7,000 $ Salvage value $ 30,000 34,000 Life years 5 5 WWW- XV. M N #7 Equivalent Annual Annuity (EAA) What is the EAA of a purchase of a computer server C that lasts four years with the following costs? The discount rate is 10%. Year 3 Cash Flow -$14.00 $1.20-$1.20 -$1.20 $ 1.20 Step 1: PV = Find the PV of the cash flows Enpy(10%, C6:F6)

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image_2

Step: 3

blur-text-image_3

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Worship Audit Making Good Worship Better

Authors: Mark Earcy

1st Edition

1851742948, 978-1851742943

More Books

Students also viewed these Accounting questions

Question

c. What is the most likely value for X?

Answered: 1 week ago