Calculate a $5000 extra payment every 12 months that would be applied to the principle. Here is
Fantastic news! We've Found the answer you've been seeking!
Question:
Calculate a $5000 extra payment every 12 months that would be applied to the principle. Here is the current MS Excel spreadsheet info. I thought I would need an column for the $5000 extra payment so I created it.
Transcribed Image Text:
Extra Payment Payment Beginning Scheduled Annual Number Balance Payment $5000Baloon Payment Date $1,064.84 $1,064.84 $1,064.84 $1,064.84 $1,064.84 $1,064.84 $1,064.84 $1,064.84 $1,064.84 $1,064.84 $1,064.84 $1,064.84 1 2 3 4 5 6 7 8 9 10 11 12 5/1/2022 $170,000.00 6/1/2022 $169,194.78 7/1/2022 $168,387.85 8/1/2022 $167,579.22 9/1/2022 $166,768.87 10/1/2022 $165,956.82 11/1/2022 $165,143.04 12/1/2022 $164,327.54 1/1/2023 $163,510.32 2/1/2023 $162,691.37 3/1/2023 $161,870.69 4/1/2023 $161,048.27 $100.00 $100.00 $100.00 $100.00 $100.00 $100.00 $100.00 $100.00 $100.00 $100.00 $100.00 $100.00 Total Payment $1,164.84 $1,164.84 $1,164.84 $1,164.84 $1,164.84 $1,164.84 $1,164.84 $1,164.84 $1,164.84 $1,164.84 $1,164.84 $1,164.84 Principal $805.22 $806.93 $808.63 $810.34 $812.06 $813.78 $815.50 $817.22 $818.95 $820.68 $822.42 $824.16 Interest $359.62 $169,194.78 $357.91 $168,387.85 $356.21 $167,579.22 $354.49 $166,768.87 $352.78 $165,956.82 $351.06 $165,143.04 $349.34 $164,327.54 $347.62 $163,510.32 $345.89 $162,691.37 $344.15 $161,870.69 $161,048.27 $160,224.11 $342.42 $340.68 Ending Balance This is the scheduled payment formula=IF([@[Payment Number]]<>"",Scheduled Payment,"") This is the extra payment formula=IF([@[Payment Number]]<>"",IF([@[Scheduled Payment]]+ExtraPayments<[@[Beginning Cumulative Interest $359.62 $717.53 $1,073.73 $1,428.23 $1,781.01 $2,132.07 $2,481.41 $2,829.03 $3,174.91 $3,519.07 $3,861.49 $4,202.17 Extra Payment Payment Beginning Scheduled Annual Number Balance Payment $5000Baloon Payment Date $1,064.84 $1,064.84 $1,064.84 $1,064.84 $1,064.84 $1,064.84 $1,064.84 $1,064.84 $1,064.84 $1,064.84 $1,064.84 $1,064.84 1 2 3 4 5 6 7 8 9 10 11 12 5/1/2022 $170,000.00 6/1/2022 $169,194.78 7/1/2022 $168,387.85 8/1/2022 $167,579.22 9/1/2022 $166,768.87 10/1/2022 $165,956.82 11/1/2022 $165,143.04 12/1/2022 $164,327.54 1/1/2023 $163,510.32 2/1/2023 $162,691.37 3/1/2023 $161,870.69 4/1/2023 $161,048.27 $100.00 $100.00 $100.00 $100.00 $100.00 $100.00 $100.00 $100.00 $100.00 $100.00 $100.00 $100.00 Total Payment $1,164.84 $1,164.84 $1,164.84 $1,164.84 $1,164.84 $1,164.84 $1,164.84 $1,164.84 $1,164.84 $1,164.84 $1,164.84 $1,164.84 Principal $805.22 $806.93 $808.63 $810.34 $812.06 $813.78 $815.50 $817.22 $818.95 $820.68 $822.42 $824.16 Interest $359.62 $169,194.78 $357.91 $168,387.85 $356.21 $167,579.22 $354.49 $166,768.87 $352.78 $165,956.82 $351.06 $165,143.04 $349.34 $164,327.54 $347.62 $163,510.32 $345.89 $162,691.37 $344.15 $161,870.69 $161,048.27 $160,224.11 $342.42 $340.68 Ending Balance This is the scheduled payment formula=IF([@[Payment Number]]<>"",Scheduled Payment,"") This is the extra payment formula=IF([@[Payment Number]]<>"",IF([@[Scheduled Payment]]+ExtraPayments<[@[Beginning Cumulative Interest $359.62 $717.53 $1,073.73 $1,428.23 $1,781.01 $2,132.07 $2,481.41 $2,829.03 $3,174.91 $3,519.07 $3,861.49 $4,202.17
Expert Answer:
Answer rating: 100% (QA)
To calculate the extra payment of 5000 every 12 months applied to the principal youll need to add an ... View the full answer
Related Book For
Financial Accounting and Reporting a Global Perspective
ISBN: 978-1408076866
4th edition
Authors: Michel Lebas, Herve Stolowy, Yuan Ding
Posted Date:
Students also viewed these accounting questions
-
Lillian Jordon is considering using some of the cash generated from her mail-order business to open a retail store. The fixed investment in the store is expected to be $3.5 million. The investment...
-
If the focal length of a lens is 3 centimeters and the image distance is 5 centimeters from the lens, what is the distance from the object to the lens?
-
(10 points) Given that ry + xy = 1. 1. Find a solution of the differential equation that satisfies the initial condition y(1) = 10. Answer: y = 2. Find a solution of the differential equation that...
-
1. Was the contract between Joel King and Barber bilateral or unilateral? 2. What was bargained for and given in exchange by each party? Mark P. Painter, Judge This case involves neighbors and the...
-
In general terms, how would a change in investment opportunities affect the payout ratio under the residual payment policy? Discuss.
-
Discuss the distinctions among negligent torts, intentional torts, and strict liability.
-
Earth Trilogy Ltd has prepared the following fixed budget performance report. Required (a) Prepare a flexible budget performance report for the actual level of activity. (b) Comment on the...
-
A persistent life insurance sales man makes the following pitch: ''At your age (40), a $100,000 whole life policy is a much better buy than a term policy. The whole life policy requires you to pay...
-
As a synthesis, think and explain the following condition: 1. A crystal salt consists of negative and positive ions. How does the net charge of the negative ions compare with that of the positive...
-
Clean Duds Laundromat has an industrial water softener that enhances the water quality used in its washing machines. The water softener is approaching the end of its useful life and must be either...
-
Find T3(X). (a) f(x, y) = e* cos y, Xo = (0,0) (b) f(x, y) = e-*-y, Xo = (0,0) f(x, y, z) = (x + y+z 3), Xo = (1, 1, 1) %3D %3D (c) (d) f(x, y, z) = sin x sin y sin z, Xo = (0,0,0) %3D %3D
-
Do corporate officers and directors have a duty to manage the corporation for the purpose of maximising profits for the benefit of shareholders or stakeholders? Discuss with reference to the US case...
-
How do globalization and cultural exchange impact the diffusion and adaptation of norms across different cultural contexts, and how do societies negotiate tensions between local norms and globalized...
-
How do norms emerge within societies, and what factors contribute to their establishment, maintenance, and evolution over time?
-
Corporate social responsibility is something that is definitely necessary within an organization and it helps to ensure that things are done in an ethical manner. What are some situations where...
-
How do deviance and conformity relate to norms, and what role do social sanctions and mechanisms of social control play in enforcing normative behavior?
-
Find the yield to maturity on a semiannual coupon bond given that the bond price is $1128, the coupon rate is 8%, the face value is $1000, and which matures in 13 years. 2. What is the duration of...
-
In the current year, the City of Omaha donates land worth $500,000 to Ace Corporation to induce it to locate in Omaha and create an estimated 2,000 jobs for its citizens. a. How much income, if any,...
-
The following information concerns seven US companies operating solely or mainly restaurants. McDonalds Corporation McDonalds Corporation franchises and operates McDonalds restaurants in the food...
-
Gerry Weber International AG is a German group active in the design, manufacture and retail of womens clothing. The following data concerning the parent company were excerpted from the 2011 annual...
-
=> Prepare a 15-minute oral presentation on the history of charts of accounts, with particular reference to the French chart of accounts (dating from 1942). => Prepare a 15-minute oral presentation...
-
In Fig. 1130, there is no explicit invariant that states that a Transaction cannot be linked to movements that are linked to the same account, because the structure of the model already demands is....
-
Apply the Account/Transaction pattern to the parallel financial transactions of the example shown in Figs. 1131 to 1135. As the bills may be paid forward, it may be necessary to use memo entries....
-
Look at Fig. 1119 and create a new discount strategy that gives a percentage of discount for sales with more than a certain number of products. Order | < > < > +nr: Natural = < > +date: Date...
Study smarter with the SolutionInn App