midterm1solution (1)

xlsx

School

Arizona State University *

*We aren’t endorsed by this school

Course

380

Subject

Finance

Date

Jan 9, 2024

Type

xlsx

Pages

9

Uploaded by furymills

Report
NPER 60 RATE 0.00458333 PV 78335 PMT ($1,496.29) FV 0 NPER 60 RATE 0.004583333333333 PV 68335 Total Paid interest PMT ($1,305.28) ($78,316.68) ($9,981.68) FV 0 NPER 30 RATE 0.004583333333333 PV $41,849.92 PMT ($1,496.29) FV 0 NPER 20 Rate 3% 0.057233123 PV -945.5 Car Loan. You want to purchase a new BMW X5 series. The price of the car is $78,335. BMW's financial office has offered to finance the car for 60-months (5 years), and will charge you 5.5% APR, with monthly compounding. What is your monthly payment. Car Loan. You want to purchase a new BMW X5 series. The price of the car is $68,335. BMW's financial office has offered to finance the car for 60-months (5 years), and will charge you 5.5% APR, with monthly compounding. How much total interest do you pay over the lifetime of the loan? Car Loan. You want to purchase a new BMW X5 series. The price of the car is $78,335. BMW's financial office has offered to finance the car for 60-months (5 years), and will charge you 5.5% APR, with monthly compounding. What is the outstanding balance of the loan after making your 30th payment? A bond is currently trading at 945.50, and has a 5% coupon rate. Coupons are paid semi-annual and the bond has a face value of 1,000. The bond has 10 years left to maturity. What is the yield to maturity?
PMT 25 FV 1000 year 0 -55,000 year 1 10,000 year 2 20,000 year 3 35,000 year 4 30,000 year 5 15,000 Rate 9% NPV $29,036.06 year 0 -55,000 year 1 10,000 year 2 20,000 year 3 35,000 year 4 30,000 year 5 15,000 IRR 25.73% Project A has the following Cash flows: Cost: $55,000 year 1: 10,000 year 2: 20,000 year 3: 35,000 year 4: 30,000 year 5: 15,000 What is the NPV of the project if the firm has a cost of capital of 9% Project A has the following Cash flows: Cost: $55,000 year 1: 10,000 year 2: 20,000 year 3: 35,000 year 4: 30,000 year 5: 15,000 What is the IRR of the project ? If you deposit 4,000 each year (starting with a deposit made today), for the next 30 years, how much will you have in 30 years if you can earn 5% interest?
NPER 30 RATE 5% PV 0 PMT 4000 FV ($279,043.16) NPER 10.9921992310506 RATE 6% PV -78,000 PMT 0 FV 148,000 NPER 10 RATE 4% PV ($1,081.11) PMT 50 FV 1000 You're trying to save to buy a new $148,000 Audi R8. You have $78,000 today that can be invested at your bank. The bank pays 6 percent annual interest on its accounts. How many years will it be before you have enough to buy the car? Assume the price of the car remains constant. JnJ issued bonds with a $1,000 face value. The bonds have a 10 years to maturity and will make annual coupon payments. The coupon rate is 5%. If the yield to maturity is 4%, what should the current price of the bonds be? Your local travel agent is advertising an upscale winter vacation package for travel three years from now to Antarctica. The package requires that you pay $20,000 today, $35,000 one year from today, and a final payment of $45,000 on the day you depart three years from today. What is the cost of this vacation in today's dollars if the discount rate is 9.75 percent?
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
year 0 20,000 year 1 35,000 year 2 0 year 3 45,000 Rate 9.75% npv 85,931.3954612755 year 0 60,000 NPER 4 year 1 70,000 RATE 5.50% year 2 75,000 PV $236,315.33 year 3 50,000 PMT 0 rate 5.50% FV ($292,753.25) npv $236,315.33 Chase BoA WF SDCC APR 3.10% 3.04% 3.05% 3.07% compound 12 365 4 52 ear 0.03144427 0.030865493238621 0.03085062 0.0311667634 The government has imposed a fine on JJ’s Place. The fine calls for annual payments of $60,000, $70,000, $75,000, and $50,000, respectively, over the next four years. The first payment is due today. The government plans to invest the funds until the final payment is collected and then donate the entire amount, including the investment earnings, to help the local community shelter. The government will earn 5.5 percent on the funds held. How much will the community shelter receive four years from today? You are thinking of buying a house and would need to get a mortgage. The following banks are quoting rates: Chase: 3.10% (APR), monthly compounding Bank of America: 3.04% (APR), daily compounding Wells Fargo: 3.05% (APR), quarterly compounding SDCC: 3.07% (APR), weekly compounding
NPER 60 RATE 0.004583333333333 PV 78335 PMT ($1,496.29) FV 0 Balance Interest principal Ending balance 1 78335 359.0354167 $1,137.25 $77,197.75 2 $77,197.75 $353.82 $1,142.47 $76,055.28 Car Loan. You want to purchase a new BMW X5 series. The price of the car is $78,335. BMW's financial office has offered to finance the car for 60-months (5 years), and will charge you 5.5% APR, with monthly compounding. How much of your second payment went towards interest?
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
years to maturity 11/13/2033 Settlement date 11/13/2023 coupon 5% face value 1000 Yield To Maturity 6% Duration 7.56842797235381 -0.075684279723538 Bond A: Bond B Coupon : 5%, face value=1000, annual pmt, 5yrs Coupon : 6%, face value YTM: 5% NPER 5 NPER 5 RATE 5% RATE 5% PV ($1,000.00) PV ($1,043.29) PMT 50 PMT 60 FV 1000 FV 1000 New prices YTM jumps to 7% NPER 5 NPER 5 RATE 7% RATE 7% PV ($918.00) PV ($959.00) PMT 50 PMT 60 FV 1000 FV 1000 % change price -8.200% -8.080%
e=1000, annual pmt, 5yrs
NPER 1 RATE 3.500% PV -96,618.36 PMT 0 FV 100,000 950 NPER 1 RATE 5.10% PV ($903.90) PMT 0 FV 950 NPER 1 RATE 10.632% PV -903.9 PMT 0 FV 1000 0.056
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