Question: The following is an amortization schedule for a $250,000 loan with Interest rate xxx, monthly payment xxx, and service fee rate xxx. Please use

The following is an amortization schedule for a $250,000 loan with Interest

The following is an amortization schedule for a $250,000 loan with Interest rate xxx, monthly payment xxx, and service fee rate xxx. Please use the data table below to answer the questions below: A Payment 1 2 3 4 5 6 7 8 9 10 11 12 13 14 B P&I Constant C D Service Interest fee Rate Rate E Net Interest Rate 1,342.05 5.00% 0.250% 4.75% 1,342.05 5.00% 0.250% 4.75% 1,342.05 5.00% 0.250% 4.75% 1,342.05 5.00% 0.250% 4.75% 1,342.05 5.00% 0.280% 4.75% 1,342.05 5.00% 0.250% 4.75% 1,342.05 5.00% 0.250% 4.75% 1,342.05 5.00% 0.250% 4.75% 1,342.05 5.00% 0.250% 4.75% 1,342.05 5.00% 0.250% 4.75% 1,342.05 5.00% 0.250 % 4.75% 1,342.05 5.00% 0.250% 4.75% 1,342.05 5.00% 0.250% 4.75% 1,342.05 5.00% 0.250% 4.75% F G Gross Principal Interest 300.38 1,041.67 301.63 1,040.42 302.89 1,039.16 304.15 1,037.90 305.42 1,036.63 306.69 1,035.36 307.97 1,034.08 309.25 1,032.80 310.54 1,031.51 311.84 1,030.21 313.14 1,028.91 314.44 1,027.61 315.75 1,026.30 317.07 1,024.98 H Service Fee c. Write at least one equation for how to calculate Net Interest. I Net Interest 52.08 989.59 52.02 988.40 51.96 987.20 51.90 986.00 51.83 984.80 51.77 983.59 51.71 982.37 51.64 981.16 51.58 979.93 51.51 978.70 51.44 977.47 51.38 976.23 51.32 974.98 973.73 J Unpaid Principal Balance 250,000.00 249,699.62 249,397.99 249,095.10 248,790.95 248,485.53 248,178.84 247,870.87 247,561.62 247,251.08 246,939.24 246,626.10 246,311.66 245,995.91 245,678.84 a. Without doing any major calculations and using the data in the table - please infer by using the table what the missing Service Fee value could be in the highlighted cell H14. b. There is one typo in this table. Please identify it and tell us what is incorrect about it. (Note: It is not a calculation error.)

Step by Step Solution

★★★★★

3.37 Rating (153 Votes )

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related Finance Questions!

QUESTION 27 Connie's Cakes wants to find out how much cash the company brought in this year. Which is the best financial statement to find this information? O Balance sheet O Income statement O...

3 4 5 6 7 8 9 10 11 12 13 A 14 Cost of the Asset 15 Life of the Asset in Years 16 Book Value of the Asset after 5 years 17 Depreciable Basis 18 Yearly depreciation 19 After tax Salvage Value in year...

Use the table below to answer the questions that follow: a. If this table reflects the supply of and demands for tickets to a particular World Cup soccer game, what is the stadium capacity? b. If the...

A partial amortization schedule for a 10-year note payable issued on January 1, 2016, is shown below. a. Using the financial statement model below, record the appropriate amounts for the following...

Forte Company begins operations on April 1. Information from job cost sheets shows the following. Job 12 was completed in April. Job 10 was completed in May. Jobs 11 and 13 were completed in June....

The accompanying diagram depicts a monopolist whose price is regulated at $10 per unit. Use this figure to answer the questions that follow. a. What price will an unregulated monopoly charge?b. What...

The attached data file contains information on e-mails. The data includes an indicator variable (Spam) that marks if the e-mail is junk mail. Predictors include the number of recipients (Recipients)...

Variable Names: GENDER: Gender of participants: 1: Boys, 2: Girls ESCALEDS: English Language Art Test administered by the local state. CLASSINT: Categorized version of the ESCALEDS: Intermediate: 1;...

GENDER: Gender of participants: 1: Boys, 2: Girls ESCALEDS: English Language Art Test administered by the local state. CLASSINT: Categorized version of the ESCALEDS: Intermediate: 1; Proficient: 2...

Difficulty with Random Selection 77 students were asked to choose 3 of the integers 11, 12, 13, , 30 completely arbitrarily, the amazing result was as follows. If the selection were completely...

1. Economic profit equals ________minus________. 2. Economic cost equals ________cost plus ________cost. 3. For a perfectly competitive firm, marginal revenue equals ________, and to maximize profit,...

The market-versus-government debate is an important one to know about, but it takes time to learn the particulars. 1. When it comes to economic problems, how does the national debate usually proceed?...

An Airbus A 380-800 passenger air plane is cruising at constant altitude on a straight line with a constant speed. The total surface area of the two wings is 395 m 2 . The average speed of the air...

A coupon bond is a bar that pays no interest and it's offered and initially sales at par these bonds provide compensation to investors in the form of appreciation true or false

Dale Nagel, Keith White, and Issa Mbango have capital balances of $93,000, $71,000, and $6,400, respectively. They share profit or loss on a 4:3:2 basis. White withdraws from the partnership on...

Otis Corp. uses a periodic system and the FIFO method. Otis had begun an inventory of 30 units purchased at $120 each and made the following purchases during the year: Jan. 15: 34 units at $100 May...

As shown below, a horizontal beam is in equilibrium The orange circle represents the hinge and the 25 m long cable has a tension of 937 N WebAssign PlotDetermine the weight of the beam as well as the...

The government claims that the average age of Californians is 34 years. Joe hypothesizes that the average age of the population of California is not equal to 34 years. He records a sample mean equal...

Would we normally expect a company to have an overall inflow or an overall outflow of cash from its operating activities? Explain why.

The following information relates to Bedford Companys accounts receivable: Accounts receivable balance on December 31, 2015........ $ 900,000 Allowance for doubtful accounts balance on December 31,...

During a discussion regarding the recent sale of a piece of equipment, your company president, Nanda Saloojee, stated: I dont understand what it means to have a gain from the sale of equipment. Why...

Read the news story in this chapter. Which of the theories discussed in this chapter do you think best explain(s) this situation? Choose the theories that you think are most relevant, and use them to...

When is it better to pursue incremental rather than transformational change?

Think about the businesses from which you have purchased goods or services. Select the organization that you believe has adopted the marketing concept. Discuss the reasons why you believe that this...