Logo
Home Study Material Contact Search
AI Chat FREE
  1. business
  2. finance
  3. show me how you can get the answers in excel using

Show me how you can get the answers in excel using the functions for these...

90.2K

Verified Solution

Question

Finance

Show me how you can get the answers in excel using the functions for these questions that have the answer already: image

A perpetuity pays $271 per year starting now (i.e. the first payment happens immediately and the second payment occurs in one year). What is the PV of this perpetuity if the prevailing interest rate is 5.1% per year? Give your answer in dollars to the closest penny. Selected Answer: x [None Given] Correct Answer: 5,584.730.01 2 0 out of 2 points What is the PV of a perpetuity paying $105 each month, beginning in one month, if the monthly interest rate is 0.9% and the payment amount will grow at a rate of 0.3% per month? Give your answer in dollars to the nearest penny. Selected Answer: [None Given] Correct Answer: 17,500.000.01 3 0 out of 2 points Your mortgage payment is $4705.74 per month. The interest rate on your mortgage is 9.9% compounded monthly. It's a 30 -year mortgage and you have just made your 59 th payment. What is the balance on the loan? Give your answer to the nearest penny. Selected Answer: [None Given] Correct Answer: 522,293.670.01

Answer & Explanation Solved by verified expert
Get Answers to Unlimited Questions

Join us to gain access to millions of questions and expert answers. Enjoy exclusive benefits tailored just for you!

Membership Benefits:
  • Unlimited Question Access with detailed Answers
  • Zin AI - 3 Million Words
  • 10 Dall-E 3 Images
  • 20 Plot Generations
  • Conversation with Dialogue Memory
  • No Ads, Ever!
  • Access to Our Best AI Platform: Flex AI - Your personal assistant for all your inquiries!
Become a Member

Other questions asked by students

Statistics
1.2K views

Violent crimes include rape robbery assault and homicide The following is a summary of the...

Geometry
1.2K views

Question 7 Multiple Choice Worth 1 points 03 01 LC B AB is dilated from...

Basic Math
1.2K views

6 For fixed a C show that za 11 z 1 if z 1 a...

Finance
1.2K views

Simple Metal Works, Inc. will manufacture and sell 250,000 units next year. Fixed costs will total...

Basic Math
1.2K views

?a) If the confidence interval for the difference in population proportions p1? - p2 includes? 0,...

Basic Math
1.2K views

Evaluate the expression u+ (u-v) given that u = - - 5 and v =...

Algebra
1.2K views

Which functions are correctly graphed 0 0 4 2 4 2 2 2 4 4...

Accounting
1.2K views

(2) AAA Company sells products C1, C2 and C3. In 2017, the unit selling price,...

Accounting
1.2K views

Needing full solution to study for test ASAP.

Accounting
1.2K views

1 .Mr. Grifter embezzles $150,000 from his employer. He gets caught . . . but...

Accounting
1.2K views

Jones Company makes and sells 1,000 tables a year for $350 per table. Manufacturing costs...

Accounting
1.2K views

First-in, first-out (FIFO) process costing transfers out the costs in beginning inventory before transferring out...