Nidhi_Patel_Chapter 4 Homework

.xlsx

School

Temple University *

*We aren’t endorsed by this school

Course

3101

Subject

Finance

Date

Feb 20, 2024

Type

xlsx

Pages

13

Uploaded by GrandIceFrog12

Report
PROBLEM (1-4) TVM MULTIPLE UNEVEN YEAR CASH FLOW r 1 $ 500.00 8% 2 $ 1,000.00 3 $ 2,000.00 4 $2,907.97 5 YR OF LAST CASH FLOW 3 FV $3,663.20 PV $2,907.97 TVM ANNUITY PMT 100 YEARS 15 RATE 10.00% FVA $3,177.25 PVA $760.61 (1) You plan the following deposits into your bank account : $500 next year, $1,000 the following year and $2, time deposit would you need to support the indicated withdrawals? Enter the rate, the cash flows and the ans displayed as positive values. (2) If the withdrawals in Question 1 were deposits instead and you could earn 8% per year, what would your b displayed as a positive value. (3) If you were to make annual deposits of $100 over the next 15 years earning 10% per year, what would you appropriate cells in column B and set this up so that your answer is displayed as a positive value. (4) If you wanted to make annual withdrawals of $100 over the next 15 years, earning 10% per year, what one question #3 and set this up so that your answer is displayed as a positive value.
,000 the year after that. If you can earn an annual rate of return of 8%, what one- swer in the indicated cells in column B. Be sure that all dollar figures in column B are balance be immediately after your last deposit? Be sure that your answer is ur balance be immediately after making your final deposit? Enter the inputs into the e-time deposit would you need to make today? Use the inputs from column B from
97609
PROBLEM (5-6) (6) For the loan in #5, prepare the first two monthly payment rows of the amortization table. LOAN AMOUNT $ 250,000.00 TERM OF LOAN N YEARS 30.00 ANNUAL INTEREST RATE 6.00% TERM OF LOAN IN MONTHS 360.00 MONTHLY INTEREST RATE 0.50% FIXED LOAN PAYMENT (ANNUAL) $18,162.23 FIXED LOAN PAYMENT (MONTHLY) $1,513.52 AMORTIZATION TABLE PAYMENT BEGINNING BALANCE FIXED PAYMENT 1 $ 250,000.00 $1,513.52 2 $ 249,736.48 $1,513.52 (5) Assume a 30-year mortgage loan for $250,000 for 30 years at an annual rate of 6%. What would be your that your answers are displayed as positive values. Round all values to two places after the decimal point.
INTEREST PRINCIPAL ENDING BALANCE $ 1,250.00 $263.52 $ 249,736.48 $ 1,248.68 $264.84 $ 249,471.64 fixed annual and monthly payments? Enter the inputs into the appropriate cells in column B and set this up so
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
  • Access to all documents
  • Unlimited textbook solutions
  • 24/7 expert homework help