Question

References Mailings Review View HelpTell me what you wont to do Paragraph Styies Use specific functions explained in dlass (pv.pmt npc.etc) to solve the folowing problems in spreadsheets use only Microsoft Excel pleesel Sove each problem na acaatet in one ecel sheet only Save your Hle with your fist and last name lonly one Hilei ellowed per student Donct uplod pdf MS Word image or Numbers Only Excel shets ilbe ounted towerd gading The American University in Kuswaitis consicerng inesting anew payol, otware system They present andtefuture values of this sheets to answer this question Asumetet ALKusesaníterest rateof1BK Usespread 2 Suppose thet k030.c0 onowes oyee The loto be nepaic by unfom ema payments for five yers beginning one eer fom now Ceiculate the ennual peyment using a spreadsheet 3wehag% interest rate. find the NetPresentwom trtefolingcentos YearAmount 0 55500000 1 $2500000 2 $30000o 10 FB FB F4
0 0
Add a comment Improve this question Transcribed image text
Answer #1

Answer

Solution and Excel screenshot for formulas used are shown as follows. (Question 1) Annual Cost (PMT) (KD)50,000 Number of Years (NPER) 4 Interest rate (RATE)- 0.16 Present Value (KD)- 1,39,909.03 Future Value (KD)- 2,53,324.80(Question 2) Present Value (PV) (KD)- -30,000 Number of Years (NPER)5 Interest rate (RATE) )13 Annual Payment (PMT) (KD) 8,529.44Home Insert Page Layout Formulas Dt Review View novaPDF Cut Calibri a Copy Paste 1 u-||E-LO-A· 谭很困Merge & Center B JFormat Painter Clipboard Font Alignment 89 1 (Question 1) 2 Annual Cost (PMT) (KD) 3 Number of Years (NPER)4 4 Interest rate (RATE) 50000 0.16 6 Present Value (KD) 7 Future Value (KD) -PV(B4,B3,B2) =Fv(B4,B3,B2) 9 (Question 2) 10 Present Value (PV) (KD) 11 Number of Years (NPER)- 30000 12 Interest rate (RATE) 0.13 13 4 Annual Payment (PMT) (KD)-2PMT(B12,B11,B10) 15 16 (Question 3) 17 Year 18 0 19 1 20 2 21 3 22 4 23 Net Present Worth (S) 24 25 14 Hİ Sheet1. Sheet2 Sheet3/e Ready Cash Flow (S) -55000 25000 -3000 18000 sNPV(0.09, B 19,820, B21, B22)+818

Add a comment
Know the answer?
Add Answer to:
References Mailings Review View HelpTell me what you wont to do Paragraph Styies Use specific functions...
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Not the answer you're looking for? Ask your own homework help question. Our experts will answer your question WITHIN MINUTES for Free.
Similar Homework Help Questions
ADVERTISEMENT
Free Homework Help App
Download From Google Play
Scan Your Homework
to Get Instant Free Answers
Need Online Homework Help?
Ask a Question
Get Answers For Free
Most questions answered within 3 hours.
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT