Solve using modeling , sensitivity analysis and financial excel functions with excel or written. Part2: Sara is
Fantastic news! We've Found the answer you've been seeking!
Question:
Solve using modeling , sensitivity analysis and financial excel functions with excel or written.
Transcribed Image Text:
Part2: Sara is going to buy a new car. The amount of money he needs to borrow (with a 6-year repayment period) depends on the monthly payments he can afford. He is unsure about the annual interest rate he will receive. Assume the following values: • Monthly Payment 150 BHD • Annual Interest Rate 5% 1) How much would be the Loan Amount and the Total Monthly Payment after 4 year? 2) Using this loan amount can Sara buy a car with price 7,000 BHD? 3) If Sara want to buy a car with price 7,000 BHD, how much should be the Monthly Payment? 4) Determine how Loan Amount varies as amount monthly payments from 100 BHD to 200 BHD and as annual interest varies from 5% to 9%. Part2: Sara is going to buy a new car. The amount of money he needs to borrow (with a 6-year repayment period) depends on the monthly payments he can afford. He is unsure about the annual interest rate he will receive. Assume the following values: • Monthly Payment 150 BHD • Annual Interest Rate 5% 1) How much would be the Loan Amount and the Total Monthly Payment after 4 year? 2) Using this loan amount can Sara buy a car with price 7,000 BHD? 3) If Sara want to buy a car with price 7,000 BHD, how much should be the Monthly Payment? 4) Determine how Loan Amount varies as amount monthly payments from 100 BHD to 200 BHD and as annual interest varies from 5% to 9%.
Expert Answer:
Answer rating: 100% (QA)
1 Loan Amount Total Monthly Payment After 4 years Sara will owe the bank a total of 7200 BHD The total monthly payment will be 150 BHD The interest rate will have no effect on the monthly payment but ... View the full answer
Related Book For
Posted Date:
Students also viewed these accounting questions
-
The amount of money a person must deposit 3 years from now in order to withdraw $10,000 per year for 10 years beginning 15 years from now at an interest rate of 10% per year is closest to: (a)...
-
If X is the amount of money (in dollars) that a salesperson spends on gasoline during a day and Y is the corresponding amount of money (in dollars) for which he or she is reimbursed, the joint...
-
The file P10_49.xlsx contains the amount of money spent advertising a product and the number of units sold for eight months. a. Assume that the only factor influencing monthly sales is advertising....
-
Find the lengths of the curves. x = (y 3 /12) + (1/y), 1 y 2
-
Describe the four main types of primary storage?
-
How do differences in the macro-environment affect corporate governance?
-
Examination of Fig. 6.5 shows that a relatively abrupt threshold in values of \(\tilde{\lambda}_{n}\) occurs as \(n\) is varied. In particular, as a rough approximation, \[ \tilde{\lambda}_{n}...
-
Rita Gonzales won the $41 million lottery. She is to receive $1.5 million a year for the next 19 years plus an additional lump sum payment of $12.5 million after 19 years. The discount rate is 14...
-
Consider the non-periodic signal, x(t) = eat with t ranges from 0 to +. a) (7 pts) Derive the fourier transformation X(w) = f x(t). ejot do. Attached your answer on a separate sheet or include here.
-
Two light waves E x = E 0 cos (kz - t) and E y = -E 0 cos (kz - t) overlap in space. Show that the resultant is linear light and determine its amplitude and tilt angle .
-
(a) State three (3) requirements of a genuine dialogue. For each requirement, inspect Shoppee's success at deploying technology to engage with the customers. Do you think the company is effective or...
-
Design a synchronous counter for the sequence: 0,1,3,4,6,7,0,1,3, ..., and consider all the states which will not be appeared as don't care state. Provide the following: (a) The number of bits...
-
You borrow a $ 324355 add-on interest loan from the credit union and will repay in equal installments over 10 years. The nominal rate of interest is 4.19 %. Assuming quarterly repayment and simple...
-
What must balance with the Customer Payment total in the Paid Documents row
-
If a stakeholder really wants the result of a project and is funding it, how would you characterize him or her? With both high interest and influence High interest but low influence Low interest but...
-
Carol had a universal life insurance policy with a death benefit of $100,000. The policy had a cash value of $18,000. They noticed that she had marked death benefit option B and made Michael the sole...
-
es The following data from the just completed year are taken from the accounting records of Mason Company: Sales Direct labor cost Raw material purchases Selling expenses Administrative expenses...
-
Find the market equilibrium point for the following demand and supply functions. Demand: 2p = - q + 56 Supply: 3p - q = 34
-
ABB Communications is considering replacing equipment that had a fi rst cost of $300,000 five years ago. The company CEO wants to know if the equipment should be replaced now or at any other time...
-
A civil engineer who owns his own design/build/operate company purchased a small crane 3 years ago at a cost of $60,000. At that time, it was expected to be used for 10 years and then traded in for...
-
If B = $12,000, n = 6 years, and S is estimated at 15% of B , use the SYD method to determine (a) The book value after 3 years (b) The rate of depreciation and the depreciation amount in year 4.
-
A reversible heat engine working between two thermal reservoirs at \(875 \mathrm{~K}\) and \(315 \mathrm{~K}\) drives a reversible refrigerator which operates between the same \(315 \mathrm{~K}\)...
-
A reversible heat engine operates between two reservoirs at temperatures of \(600^{\circ} \mathrm{C}\) and \(40^{\circ} \mathrm{C}\). The engine drives a reversible refrigerator which operates...
-
A domestic food freezer maintains a temperature of \(-15^{\circ} \mathrm{C}\). The ambient air temperature is \(30^{\circ} \mathrm{C}\). If heat leaks into the freezer at the continuous rate of...
Study smarter with the SolutionInn App