Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Please complete all 5 problems in excel and high light the answers. Please send in a screen shot photo of excel when completed. my.emich my.emich

Please complete all 5 problems in excel and high light the answers. Please send in a screen shot photo of excel when completed. image text in transcribedimage text in transcribedimage text in transcribedimage text in transcribedimage text in transcribed

my.emich my.emich Excel Project xC Chegg Study | Guided Solution My Drive - Google Drive Excel Project (1) - Google Shee x+ https://docs.google.com/spreadsheets/d/1YFosaZcTw3U57i4GwiuzLmEiOMROi0MfnrOwFV19U/edit#gid-187203 1627 Paused Excel Project (1) File Edit View Insert Format Data Tools Add-ons Help Last edit was seconds ago SHARE n~P 100%, $ % .2.00 123 . Helvetica 10 . BI 1 COMPUTING THE PRESENT VALUE OF CONSTANT FLOWS 3 Discount Rate 109% Hint: Use the following formula to find the cash flow for each cash 100.00 100.00 100.00 100.00 100.00 10 13 14 Find the present values of the above cashflows using: 15 Summing PV(Cash Flows) 16 Using NPV function 17 Using PV tunction 18 24 + Instructions Problem1Problem2 Problem3 Problem4 Problem5 Excel Project (1)xisx Show all | 5:47 PM O Type here to search Excel Project (Protected View] - Excel (Unlicensed Product) - File Home Insert Page Layout Formulas Data Review View Add-ins Help Tell me what you want to do PROTECTED VIEW Be carefu-files from the Internet can contain viruses. Unless you need to edit, it's safer to stay in Protected View. Enable Editing C6 1 COMPUTING THE PRESENT VALUE OF NONCONSTANT FLOWS 3 Discount Rate 10% Hint: Use the following formula to find the present value for each cash flow Year Cash flow PV(Cash Flows S 100.00 S 200.00 S 300.00 S 400.00 S 500.00 CFt 10 12 13 14 Find the present values of the above cashflows using 15 Summing PV(Cash Flows) 16 Using NPV function 17 18 Note: In this example the cash flows are not equal. Either discount each cash flow separately or use Excel's NPV function Excers PV doesnt work for this case 19 21 23 25 26 27 28 29 30 Dell Update 1 update is ready to install Instructions Problem1 Problem2 Problem3 Problem4 Problem5 Install now Remind me later O Type here to search 12/13/2018 21 my.emich my.emich Excel Project xC Chegg Study | Guided Solution My Drive - Google Drive Excel Project (1) - Google Shee x+ https://docs.google.com/spreadsheets/d/1YFosaZcTw3U57i4GwiuzLmEiOMROi0MfnrOwFV19U/edit#gid-1021412818 Paused Excel Project (1) File Edit View Insert Format Data Tools Add-ons Help Last edit was 3 minutes ago SHARE 10 . BI n~P 100%, $ % .2.00 123 . Helvetica fCOMPUTING THE VALUE OF A FINITE ANNUITY 1 COMPUTING THE VALUE OF A FINITE ANNUITY 3 Periodic Payment, P 4 Number of Periods, n 5 Disoount Rate, r 1000 10% Hint: The formula for the present value of an annuity paying a constant periodic payment P at an interest rate of r for n periods is given by 7 Find the value of the annuity using: 8 Annuity Formula e Using PV function 10 PVA(P, r, n) = P YearCash flow S 1,000.00 $ 1,000.00 S 1,000.00 S 1,000.00 13 17 18 19 nnuity using Find the present value of the a Using NPV function Hint: Use the cash flows in the above table as inputs to the NPV function. 24 Dell Update 1 update is ready to install + Instructions Problem1 Problem2 Problem3 Problem4 Problem5 Excel Project (1)xisx Install now Remind me later O Type here to search S:50 PM 12/13/2018 21 Excel Project (Protected View] - Excel (Unlicensed Product) File Home Insert Page Layout Formulas Data Review View Add-ins Help Tell me what you want to do PROTECTED VIEW Be carefu-files from the Internet can contain viruses. Unless you need to edit, it's safer to stay in Protected View. Enable Editing C9 A B 1 COMPUTING THE VALUE OF A GROWING ANNUITY 3 Periodic Payment, P 4 Payment Growth, g 5 Discount Rate, r 6 Number of Periods, n 1000 5% 1296 Hint: The formula for the present value of an annuity paying a constant periodic payment P at an interest rate of r for n periods is given by 8 Find the value of the annuity usi 9 Annuity Formula 10 1+9 PVA(R r, g, n) = Cash flow 1 S 1,000.00 2 1,060.00 3 S1,123.60 4 1,191.02 5 S 1,262.48 Year 12 13 14 15 16 17 18 Find the present value of the annuity using: 19 Using NPV function Hint: Use the cash flows in the above table as inputs to the NPV function 21 23 25 26 27 28 29 30 Dell Update 1 update is ready to install Instructions Problem1 Problem2 Problem3 Problem4 Problem5 Install now Remind me later O Type here to search 12/13/2018 21 my.emich my.emich xExcel Project e Chegg Study | Guided Solutio/X My Drive-Google Drive E] Excel Project (1) . Google She + x x https://docs.google.com/spreadsheets/d/1YFosaZcTw3U57i4GwiuzLmEiOMROi0MfnrOWFV19U/edit#gid-210586523 Paused Excel Project (1) File Edit View Insert Format Data Tools Add-ons Help Last edit was 4 minutes ago SHARE n~P 100%, $ % .2.00 123 . Helvetica 10 . BI AMORTIZATION TABLE 1 AMORTIZATION TABLE 3 Loan Principal 4 Interest Rate 5 Loan Term(year) 120,000 30 12 s per Year 7Number of Payments 8 Monthly Payment 10 Completethe following amortization table and graph the evolution of the payments to interest and to principal as we get closer to the loan maturity 11 Hint: The ending balance in the last payment must equal zero. To graph the series, just select the month column and the two other columns and plot as a scatter plot. Payment to Payment to 13 17 18 10 Dell Update 1 update is ready to install + Instructions Problem1 Problem2 Problem3 Problem4 Problem5 Excel Project (1)xisx Install now Remind me later O Type here to search S:50 PM 12/13/2018 21

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

Step: 3

blur-text-image

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

Fundamentals Of Investments

Authors: Bradford Jordan, Thomas Miller

4th Edition

0073314978, 9780073314976

More Books

Students also viewed these Finance questions

Question

Why is succession planning important?

Answered: 1 week ago

Question

When did the situation become unable to be resolved? Why?

Answered: 1 week ago