Answered step by step

Verified Expert Solution

Link Copied!

Question

1 Approved Answer

Posted on Jun 23, 2021

Determine manually the monthly repayments needed to repay a $100000 loan if: a) the loan is paid back over 25 years when the interest rate

Determine manually the monthly repayments needed to repay a $100000 loan if:

a) the loan is paid back over 25 years when the interest rate is 9% compounded annually,

b )the period of repayment is reduced to 20 years and the interest rate rises to 10%.

c) In each case above, write Excel functions those can be used to compute monthly repayment. Provide the screen-print of the Excel file and the solution.

Step by Step Solution

★★★★★

3.48 Rating (148 Votes )

There are 3 Steps involved in it

Step: 1

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

Step: 3

Document Format ( 2 attachments)

60d452b0874dc_228159.pdf

180 KBs PDF File

60d452b0874dc_228159.docx

120 KBs Word File

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Mathematics for Economics and Business

Authors: Ian Jacques

9th edition

129219166X, 9781292191706 , 978-1292191669

More Books

Students also viewed these Mathematics questions

Question

★★★★★

Determine the monthly repayments needed to repay a $125 000 loan which is paid back over 20 years when the interest rate is 7% compounded annually. Round your answer to two decimal places.

Answered: 1 week ago

Question

★★★★★

The following spreadsheet can be used to compute monthly payments given the APR, principal, and length of the loan. a. Write the spreadsheet formula to compute cell D2. b. Write the spreadsheet...

Answered: 1 week ago

Question

★★★★★

The following spreadsheet can be used to compute total weekly pay, given the hours, hourly rate, and overtime rate. a. Write the formula to compute the regular gross pay in cell D2. b. Write the...

Answered: 1 week ago

Question

★★★★★

Peter, Emma, and Kyler played chess with each other. Peter won 4 games and lost 2 games. Emma won 3 games and lost 3 games. If Kyler lost 3 games, how many games did he win?

Answered: 1 week ago

Question

★★★★★

Figure 4-38(b) shows a second alternative data model for the sheet-music-tracking problem. This alternative shows two variations on the Work entity. In the second variation, an attribute named Work...

Answered: 1 week ago

Question

★★★★★

Consider the plane truss with a pin support at joint 3 and a vertical roller support at joint 5 (see figure). (a) Find reactions at support joints 3 and 5. (b) Find axial forces in truss members 11...

Answered: 1 week ago

Question

★★★★★

describe the nature of social stressors and their effects on employees;

Answered: 1 week ago

Question

★★★★★

Clark & Taylor is an Internet advertising agency. The firm uses a job cost system in which each client is a different job. Clark & Taylor traces direct labor, software licensing costs, and travel...

Answered: 1 week ago

Question

★★★★★

Sexton Inc. is considering Projects S and L, whose cash flows are shown below. These projects are mutually exclusive, equally risky, and not repeatable. If the decision is made by choosing the...

Answered: 1 week ago

Question

★★★★★

Using the 4-quarter moving average: What is the forecast for 3Q 2022, 4Q 2022, 1Q 2023, and 2Q 2023 2. Compute the forecast for 3Q 2022, 4Q 2022, 1Q 2023, and 2Q 2023 using exponential smoothing...

Answered: 1 week ago

Question

★★★★★

Bill Clinton reportedly was paid $ 1 5 . 0 million to write his book My Life. The book took three years to write. In the time he spent writing, Clinton could have been paid to make speeches. Given...

Answered: 1 week ago

Question

★★★★★

2. (6 points) In a sample of 821 households in Morocco, the volume of water consumed in a week was 334 liters with a standard deviation of 591 liters. Test that the average volume of water consumed...

Answered: 1 week ago

Question

★★★★★

Consider a company founded with 1m shares of common equity, split amongst the founders. A year later the company raises $5M of Series A funding at a $10M pre-money valuation. After the money has gone...

Answered: 1 week ago

Question

★★★★★

Your aunt's fasting sugar level is 130, so the doctor wants her to see a nutritionist to help her eat a more healthy diet. The mean blood sugar level is 84 with a standard deviation of 23. Interpret...

Answered: 1 week ago

Question

★★★★★

Your company estimates that 5% of this month's $100,000 Sales on account will eventually be written off. The entry should be: Debit Bad Debt Expense, $5,000; Credit Bad Debt Allowance, $5,000 Debit...

Answered: 1 week ago

Question

★★★★★

Suppose we want to figure out what the biggest magnitude earthquake was in 2019, but we only have our representative sample of 200. Let's see if trying to find the biggest magnitude in the population...

Answered: 1 week ago

Question

★★★★★

Need help on the Business Meanings (ii) Business implications: Above you chose 'o-or-many', K'1-or-many' at three places. The first choice is explained below. Explain your other two choices. (4...

Answered: 1 week ago

Question

★★★★★

How has the too-big-to-fail policy been limited in the FDICIA legislation? How might limiting the too-big-to-fail policy help reduce the risk of a future banking crisis?

Answered: 1 week ago

Question

★★★★★

(a) Solve the equation 6(2 + x) = 5(1 4x) (b) Solve the inequality 3x + 6 5x 14

Answered: 1 week ago

Question

★★★★★

Use Cramers rule to solve the following sets of simultaneous equations: (a) 4x + 3y = 1 2x + 5y = 3 (b) 4x + 3y = 1 2x + 5y = 11 (c) 4x + 3y = 2 2x + 5y = 36

Answered: 1 week ago

Question

★★★★★

Write down expressions for the savings function given that the consumption function is (a) C = 0.9Y + 72 (b) C = 0.8Y + 100

Answered: 1 week ago

Question

★★★★★

7.32. A study11 of bulimia among college women considered the effect of childhood sexual abuse on various components of a Family Environment Scale. For a measure of family cohesion, the sample mean...

Answered: 1 week ago

Question

★★★★★

7.28. As part of her class project, a student atthe University ofFlorida randomly sampled 10 fellow students to investigate their most common social activities. As part ofthe study, she asked the...

Answered: 1 week ago

Question

★★★★★

7.30. A clinical psychologist wants to choose between two therapies for treating mental depression. For six patients, she randomly selects three to receive therapy A, and the other three receive...

Answered: 1 week ago

Previous Question Next Question