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!

#### Similar Solved Questions

##### 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...
##### 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...
##### 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...
##### 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...
##### 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...
##### 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 ...
##### 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...
##### 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...
##### 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...
##### 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....
##### 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...
##### 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...
##### 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...
##### 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...
...