Can you please calculate the assumption part and find: 1) What will be the monthly payment of Edward? 2) What will be the monthly payment amount of Jorge? 3) How much does Edward pays more than Jorge in simple calculation? Please solve these by hand not excel. Thanks!

Q: Gage is suppose to receive a payment of $480.00 today from Mark. One month from today, Gage should…

A: Interest rate = 2.95% per annum Payment to be received today (P0) = $480 Payment to be received…

Q: You may use your financial calculator or excel for calculations but be sure to show your work (i.e.…

A: Part 1: Future Value = $400,000 Rate = 2% Time period = 18 months - 12 months = 6 months Present…

Q: For the following economic calculations, write the factors (multipliers) that should be used, in (i)…

A:

Q: Not use excel to solve Allison pays $27,506.28 for an annuity due today. This annuity will pay her…

A: The present value of annuity due is the present value of a series of cash payments that are expected…

Q: Where will you borrow money?  Justify your answer by showing all necessary calculations Choice A:…

A: Effective annual rate of DRSA Company (EAR) = ( 1+ i/n) n - 1 = ( 1+ 0.0466/2)2 -1 = (1.0233)2 - 1…

Q: Different payment plans can affect the amount of money you need to borrow. a) Ali is paying off a…

A: Note: As per our guidelines, we can only answer one question at once. Since, you haven't…

Q: Mayesha purchased a large screen TV for $4,000 and can pay it off in ten months with an add-on…

A: P = $ 4000 r = .135 t = (10/12) years

Q: James wants to buy a gaming computer priced at $3,774, but he is not able to pay the amount in full.…

A: Price of computer = $3,774 There are 2 cases in this answer  If J chooses to pay 12 months payment…

Q: A woman went to the Beneficial Loan Company and borrowed ST0,000. She must pay $323.53 At the end of…

A: Monthly interest rate can be calculated by excel formula PMT and by IRR formula with series of cash…

Q: You are in desperate need of cash and turn to your uncle who has offered to lend you some money. You…

A: Computation of the implied rate of this transaction is shown as follows: Hence, the implied rate on…

Q: PLEASE, PERFORM THE EXERCISE IN EXCEL AND SHOW THE FORMULAS 1.-  Osmara Del Toro deposits her life…

A: Compound interest is a method of interest calculation where the interest earned is reinvested…

Q: lie has a credit card with an APR of 27.99% and a current balance of $9,325.65. She wants to pay it…

A: Given information : Annual percentage rate 27.99% Current balance $9,325.65 Time period…

Q: Suppose you decide to take the tour now and use a 15% credit card for the purchase. A. How many…

A: Hello. Since your question has multiple sub-parts, we will solve first the three sub-parts for you.…

Q: Suppose that you borrowed $18,306 for 36 months to buy a car last year at 5.5% APR compounded…

A: given, p= $18306 n = 36  r= 5.5% m = 12 ( monthly compounding)

Q: Troy wants to buy an additional screen for his computer which he saw in an advertisement for RM2500…

A: In hire purchase agreement the ownership is transferred to the borrower only after the loan is…

Q: n Guimo is going to purchase a house with a purchase price of P. ay as a down payment. He is going…

A: It is assumed that monthly payments are to be made. The given problem can be solved using PMT…

Q: 2. Amy borrowed Php45500 on March 3, 2021. if the 10% interest rate was deducted in advance and she…

A: This question is related to the future value and present value where you have the present value and…

Q: What is the PV of your windfall?

A: The today’s worth of dollar at a later date is the Present Value of the dollar. For example, the…

Q: Rosie is buying a car for $25,500; She is Scheduled to make 7 annual instalments. Given an interest…

A: Given that, Cost of car = $25,500 Number of instalments = 7 Interest rate = 8%

Q: roy already had a balance of $104.75 on his credit card when he used it to purchase items totalling…

A: In this we need to find out the annual effective interest rate and from than we can get the monthly…

Q: Friendly's Quick Loans, Inc., offers you "$4.30 for $5.30 or I knock on your door." This means you…

A: APR = [ ( Interest amount / Loan Amount ) * 365 / Frequency ] EAR = [ 1 + APR / 52 ]52 - 1

Q: PLEASE, PERFORM THE EXERCISE IN EXCEL AND SHOW THE FORMULAS Problem 1: Domingo Medina wants to know…

A: The annual worth is a significant method for capital projects.  The annual worth refers to the…

Q: You have 45 remaining monthly payments of $688 until you pay off your car loan with interest.…

A: In order to find the current balance of the loan today one has to find the Present value of the…

Q: Write each known variable’s value as it appears in the calculator and use a question mark for the…

A: Annuity means finite no. of payment which are same in size and made in equal intervals for the…

Q: Find the future value of the following annuities. The first payment in these annuities is made at…

A: The final answers are highlighted in yellow. Excel Spreadsheet:

Q: Molly’s total loan amount is $24,495. Using the image, how much would her monthly payments be? How…

A: Meaning 0% APR : An 0% APR offer means that you won't have to pay interest on your purchases for a…

Q: Suppose you invest $130 a month for 5 years into an account earning 8% compounded monthly. After 5…

A: A study that proves that the future worth of the money is lower than its current value due to…

Q: James wants to buy a gaming computer priced at $3,774, but he is not able to pay the amount in full.…

A: Price of the computer = $3,774 Time period = 12 Months  Interest rate = 14.8%

Q: For TVM calculator:  Write each known variable’s value as it appears in the calculator and use a…

A: Future value refers to the worth of the amount in future which is deposited or received today at…

Q: Suppose you owe $15,000 on a credit card that carries an APR of 24%. Because the balance is so high,…

A: Credit Card Balance at Month 1 beginning = $15000 Payment for Month 1 = 5% of 15000 = $750 Monthly…

Q: For the following problem, first choose A or B (Be sure to indicate which one you are using). Then…

A: An Annuity is a continuous flow of systematic timely cash flows made or received for a stipulated…

Q: Dr. Dennis Natali plans to take advantage of 0% interest balance transfer credit card offer to pay…

A: given data Dr. Dennis Natali plans to take advantage of 0% interest balance transfer credit card…

Q: (a) What is the monthly payment required by the loan? (Round your answer to the nearest cent.) How…

A: The monthly payment is the payment of the loan or borrowed amount that has to be paid or received on…

Q: (a) (Write the parameters you use in TVM-Solver.) What quarterly payment will Mike be required to…

A: Loan amortization refers to a schedule which is prepared to shows the periodic loan payments, amount…

Q: Here is the deal: You can pay your college tuition at the beginning of the academic year or the same…

A: Time value of money- It is based on the concept that money earned today is worth more than similar…

Q: A man borrowed P100,000 with 20% interest promised to pay the amount annually for 10 years however…

A: Loan amount (PV) = P 100,000 Annual interest rate (r) = 20% Number of annual payment (n) = 10

Q: ou can afford monthly deposits of $180 into an account that pays 3.6% compounded monthly. How long…

A: solution given Monthly deposit  (PMT) $180 Interest rate (I/Y) 3.6% compounded monthly…

Q: Suppose you are given two loan options.  The first one allows you to borrow money at 8.6% per year,…

A: First we need to calculate effective annual rate by using this equation  Effective annual interest…

Q: 6.At 6.5   percent interest, how   long    does it  take    to  double your    money? To quadruple…

A: Part a) Assume Amount invested =$1Given interest rate =6.5%n=length of time in which investment of…

Q: PLEASE, PERFORM THE EXERCISE IN EXCEL AND SHOW THE FORMULAS 3.- Andres Rosas wants to know how much…

A: Discounting is a technique through which present value (PV) of future cashflows is computed by using…

Q: a is buying a car for $12,560.00. Her down-payment is $3000.00 followed by 24 monthly payments of…

A: The given problem can be solved using RATE function in excel. RATE function computes interest rate…

Q: A lender requires PMI that is 0.7% of the loan amount of $490,000. How much (in dollars) will this…

A: Working note:

Q: Kindly solve it completely& correctly. Also, please provide your own solution. Thanks. 5. Ahmed…

A: When we take a loan , then we need to pay more than cash price as deferred payment will include…

Q: choose

A: To calculate which account to be chosen, we can calculate the effective annual rate. Effective…

Q: Jamal bought a car and is making month-end payments of $510.35 for the next 4 years to pay it off.…

A: given, month end payment, Mode = END N= 4 X12 = 48 years IY = 2.99% CY= 2 (since interest is…

Q: Can you tell me how did they get RM18785.79 as a future value by using a formula? Suppose we should…

A: The future value of annuity is given by  FV = E((1+r)^n - 1)/r Where, E = monthly deposit = $1000 r…

Q: For TVM calculator:  Write each known variable’s value as it appears in the calculator and use a…

A: An annuity shows a stream of cash flows paid or received over a specific time duration. In an…

Q: Please help me answer the following time value of money question. Edison borrowed $10,000 from the…

A: we use rate function in excel to find the interest rate charged over the period of the loan

Real Estate

Real estate means ownership of land along with the assets and natural resources that exist on the land. These properties are in real/physical form which is tangible. Real estate simply means land or addition made to land permanently like constructing a residence or different buildings. People invest in real estate to either reside or for wealth creation. Many people investing in real estate further lend the place for occupation or businesses in return for a monthly payment.