Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Can you please show me how to complete these using a formula in excel? I know how to solve both, but not in excel. Thank
Can you please show me how to complete these using a formula in excel? I know how to solve both, but not in excel. Thank you
Problem 6-27 Discounted Cash Flow Analysis. Problem 6-26 Calculating Annuity Present Values. ? Discounted cash flow analysis - Excel X X Calculating annuity present values - Excel REVIEW Sign In FILE OE INSERT PAGE LAYOUT FORMULAS DATA VIEW Sign In FORMULAS FILE INSERT PAGE LAYOUT DATA REVIEW VIEW 10 A A 12 Arial polnts Calibri 11 A A E Paste Alignment Number Conditional Format as Formatting Table Styles Cell Paste Cells Editing IU Conditional Format as A Cell IU- Editing Alignment Number Cells B T Formatting Table Styles Clipboard Font Styles A Clipboard Font Styles A ook fx X D20 A1 A B C D F F G J K A G H References 1 2 2 If the appropriate discount rate for the following cash flows is 9 percent compounded quarterly, what is the present value of the cash flows? Beginning three months from now, you want to be able to withdraw $2,200 each quarter from your bank account to cover college expenses over the next four years. If the account pays 43 percent interest per quarter, how much do you need to have in your bank account today to meet your expense needs over the next four years? 4 3 APR 9% 6 4 Compounding periods 7 5 Quarterly withdrawal Quarters per year Number of years Interest rate per quarter $ 2,200 6 Year Cash flow 9 4 7 1 $ 790 10 8 860 11 2 0.43% 9 12 3 10 1,340 13 4 11 14 Complete the following anlsis. Do not hard code values in your calculations. Your answer should be positive 15 12 16 13 Complete the following analysis. Do not hard code values in your calculations Amount needed today 14 17 15 EAR 9.31% 18 16 19 17 Present value 20 18 21 22Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started