1

1.Payments are not equal, they change from period to period. Find the present value of the...

Question

1.Payments are not equal, they change from period to period. Find the present value of the...

1.Payments are not equal, they change from period to period. Find the present value of the payment in each period and sum them to find the present value of all the cash flows. What is the present value of an investment that pays $200 in year 1, $300 in year 2, and $400 in year 3? Assume a rate of return of 12%. ($702.44)

2.You are buying a new car and will have a 12,500 loan with equal payments for 4 years    (48 months). The interest payment will be 6.5%. What will your monthly       payment be?    ($296.44)You are buying a new car and will have a 12,500 loan with equal payments for 4 years    (48 months). The interest payment will be 6.5%. What will your monthly       payment be?    ($296.44)

can you please show me how to do on excel. thanks!

Answers

1)

D Present value 1 A B 164 Year Cash flow 1650 $ - 166 1 $ 200 167 2 $ 300 168 3 $ 400 169 C PVIF@12% 1.000 0.893 $ 0.797 $ 0.

*Please rate thumbs up


Similar Solved Questions

1 answers
Continuing Problem Chapter 4-Instruction #1 The adjusted trial balance of PS Music as of July 31,...
Continuing Problem Chapter 4-Instruction #1 The adjusted trial balance of PS Music as of July 31, 2019 is shown below: PS Music Adjusted Trial Balance July 31, 2019 Debit Balances Credit Balances Cash 9,945 Accounts Receivable 4,150 Supplies 275 Prepaid Insurance 2,475 Office E...
1 answers
Least Squares Linear Regression of Rent Predictor Variables Constant Size Coefficient 1276.56 0.16486 Std Error 454.843...
Least Squares Linear Regression of Rent Predictor Variables Constant Size Coefficient 1276.56 0.16486 Std Error 454.843 0.41717 T 2.81 0.40 P 0.0072 0.6945 Mean Square Error (MSE) Standard Deviation 458532 677.150 R2 Adjusted R2 AICC PRESS 0.0032 -0.0175 656.27 2.34E+07 DF F 0.16 P 0.6945 1 Source R...
1 answers
You produce jewelry boxes. if the demand for jewelry boxes is elastic and you want to...
you produce jewelry boxes. if the demand for jewelry boxes is elastic and you want to increase your total revenue you should Increase the price of your jewelry boxes decrease the price of your jewelry boxes not change the price of your jewelry boxes none of the above answers are correct...
1 answers
Section A (40 points) 1a. Using diagrams of the AD-AS framework and Philips curve, show and...
Section A (40 points) 1a. Using diagrams of the AD-AS framework and Philips curve, show and carefully explain how a contractionary monetary policy impacts output, inflation, and unemployment in the short run. (10 pts) b. Define the sacrifice ratio; and state its relevance to your response in part (a...
1 answers
In Nursing as Caring Theory, Boykins and Schoenhofer mentioned that even though both nurses and clients...
In Nursing as Caring Theory, Boykins and Schoenhofer mentioned that even though both nurses and clients have differences, they are united by: * O a. Art of Nursing O b. Music of Caring O d. Rhythm of Caring c. Rhythm of Nursing...
1 answers
A population has standard deviation o = 17.3. Part 1 out of 2 How large a...
A population has standard deviation o = 17.3. Part 1 out of 2 How large a sample must be drawn so that a 80% confidence interval for u will have a margin of error equal to 1? Round up the answer to the nearest integer. (Round the critical value to no less than three decimal places.) is needed to be ...
1 answers
A nurse is providing teaching for a client who takes an oral contraceptive and is about...
A nurse is providing teaching for a client who takes an oral contraceptive and is about to begin rifampin therapy to treat tuberculosis. Which of the following instructions should the nurse include? Increase the rifampin dose. Increase the oral contraceptive dose. Allow 2 hr between taking the two d...
1 answers
What output is produced by the following code? Explain how it works. 1.1 1 ...2..... 5...
What output is produced by the following code? Explain how it works. 1.1 1 ...2..... 5 package taesik; import java.util.; /* Your name: Date: Answer: How it works: */ class student String name; int age; 1 public class Quiz21 ( public static void main(String args[])! ArrayList<student>myArra...
1 answers
Write a program that first gets a list of integers from the input and adds them...
Write a program that first gets a list of integers from the input and adds them to an array. The input begins with an integer indicating the number of integers that follow (Your program should work for any size of the array). Then, get the last value from the input, and output all integers less than...
1 answers
Using MatLab A. Create a time array t from -10 to 10 seconds with a sample...
Using MatLab A. Create a time array t from -10 to 10 seconds with a sample rate of 1 sec. B. Create a step function of t with a user-entered delay. C. Plot the array showing only the samples....
1 answers
Lindy Company's auditor discovered two errors. No errors were corrected during 2020. The errors are described...
Lindy Company's auditor discovered two errors. No errors were corrected during 2020. The errors are described as follows: (1) Merchandise costing $5,000 was sold to a customer for $10,000 on December 31, 2020, but it was recorded as a sale on January 2, 2021. The merchandise was properly exclu...
1 answers
QUESTION 6 There are 12 signs of the Zodiac: Aries, Taurus, Gemini, Cancer, Leo, Virgo, Libra,...
QUESTION 6 There are 12 signs of the Zodiac: Aries, Taurus, Gemini, Cancer, Leo, Virgo, Libra, Scorpio, Sagittarius, Capricorn, Aquarius, and Pisces. Each sign corresponds to a different calendar period of approximately 1 month. Assuming that a person is just as likely to be born under one sign as a...
1 answers
Sharon and Tray are married, have two dependent children, and file a joint return in 2018....
Sharon and Tray are married, have two dependent children, and file a joint return in 2018. If they have adjusted gross income (AGI) of S80,000 and itemized deductions of $8,500, what is their taxable income for 2018 (Click the icon to view the standard deduction amounts.) (If an input field is not u...
1 answers
Classify each of the following studies as: A. Cohort B. case-control C. cross-sectional ____ 1. Representative...
Classify each of the following studies as: A. Cohort B. case-control C. cross-sectional ____ 1. Representative sample of residents were telephoned and asked how much they exercise each week and whether they currently have (have ever been diagnosed with) heart disease. ____ 2. Occurrence of cancer wa...
1 answers
...
1 answers
3-- Determine the peak load voltage for the circuit shown in Fig.1 i Determine the dc...
3-- Determine the peak load voltage for the circuit shown in Fig.1 i Determine the dc load voltage for the circuit shown in Fig.2 ii- Determine the dc load voltage and current values for the circuit shown in Fig.3 V-120V 1 R 10 ΚΩ Fig. 1 V-120V R-5.1 KS2 Fig. 2 10:1 V-120V R-5.1 Fig. 3...
1 answers
6. Find the projection of u onto vifu= (-1, - 4), v=(-3,5). ( )
6. Find the projection of u onto vifu= (-1, - 4), v=(-3,5). ( )...
1 answers
Match the five terminal branches of the brachial plexus with the upper limb compartments that they...
Match the five terminal branches of the brachial plexus with the upper limb compartments that they innervate. Make sure to note which spinal segmental levels (e.g., C4, C5, etc.) are associated with the various upper limb compartments and the parts of the hand....
1 answers
Select the reaction(s) that follow(s) a 1-step mechanism? „ci + OH - Product ci + H20...
Select the reaction(s) that follow(s) a 1-step mechanism? „ci + OH - Product ci + H20 - Product + HC — + HCI Product ci + H2O cola, Product,...

-- 0.050302--