Jake borrows $35,000 to finance the expansion of his business. He promises to repay with the...

Jake borrows $35,000 to finance the expansion of his business. He promises to repay with the entire amount plus interst in exactly 5 years. The annual interest rate is 7.5%. What is the amount of Jake's monthly payments? Please answer using excel formulas & show your work. Thanks.

Solutions

Expert Solution

P = Amount of loan = $35,000

n = 5*12 = 60 months

r = monthly interest rate = 7.5%/12 = 0.625%

Monthly payment = [r * PV] / [1 - (1+r)^-n]

= [0.625% * $35,000] / [1 - (!+0.625%)^-60]

= $218.75 / 0.311908176

= $701.328202

Monthly payment is $701.33

Amortization Schedule
Month	Beginning Balance	Payment	Interest Repayment of principal	Principal Portion	Ending Balance
A	B	C	*D = B0.625%**	E = C-D	F = B-E
1	35000	701.33	218.75	482.58	34517.42
2	34517.42	701.33	215.733875	485.596125	34031.8239
3	34031.8239	701.33	212.6988992	488.6311008	33543.1928
4	33543.1928	701.33	209.6449548	491.6850452	33051.5077
5	33051.5077	701.33	206.5719233	494.7580767	32556.7497
6	32556.7497	701.33	203.4796853	497.8503147	32058.8993
7	32058.8993	701.33	200.3681209	500.9618791	31557.9375
8	31557.9375	701.33	197.2371091	504.0928909	31053.8446
9	31053.8446	701.33	194.0865285	507.2434715	30546.6011
10	30546.6011	701.33	190.9162569	510.4137431	30036.1874
11	30036.1874	701.33	187.726171	513.603829	29522.5835
12	29522.5835	701.33	184.516147	516.813853	29005.7697
13	29005.7697	701.33	181.2860604	520.0439396	28485.7257
14	28485.7257	701.33	178.0357858	523.2942142	27962.4315
15	27962.4315	701.33	174.765197	526.564803	27435.8667
16	27435.8667	701.33	171.474167	529.855833	26906.0109
17	26906.0109	701.33	168.162568	533.167432	26372.8434
18	26372.8434	701.33	164.8302716	536.4997284	25836.3437
19	25836.3437	701.33	161.4771483	539.8528517	25296.4909
20	25296.4909	701.33	158.1030679	543.2269321	24753.2639
21	24753.2639	701.33	154.7078996	546.6221004	24206.6418
22	24206.6418	701.33	151.2915115	550.0384885	23656.6033
23	23656.6033	701.33	147.8537709	553.4762291	23103.1271
24	23103.1271	701.33	144.3945445	556.9354555	22546.1917
25	22546.1917	701.33	140.9136979	560.4163021	21985.7754
26	21985.7754	701.33	137.411096	563.918904	21421.8565
27	21421.8565	701.33	133.8866029	567.4433971	20854.4131
28	20854.4131	701.33	130.3400816	570.9899184	20283.4231
29	20283.4231	701.33	126.7713946	574.5586054	19708.8645
30	19708.8645	701.33	123.1804034	578.1495966	19130.7149
31	19130.7149	701.33	119.5669684	581.7630316	18548.9519
32	18548.9519	701.33	115.9309494	585.3990506	17963.5529
33	17963.5529	701.33	112.2722054	589.0577946	17374.4951
34	17374.4951	701.33	108.5905941	592.7394059	16781.7557
35	16781.7557	701.33	104.8859729	596.4440271	16185.3116
36	16185.3116	701.33	101.1581977	600.1718023	15585.1398
37	15585.1398	701.33	97.40712392	603.9228761	14981.217
38	14981.217	701.33	93.63260595	607.6973941	14373.5196
39	14373.5196	701.33	89.83449724	611.4955028	13762.0241
40	13762.0241	701.33	86.01265034	615.3173497	13146.7067
41	13146.7067	701.33	82.16691691	619.1630831	12527.5436
42	12527.5436	701.33	78.29714764	623.0328524	11904.5108
43	11904.5108	701.33	74.40319231	626.9268077	11277.584
44	11277.584	701.33	70.48489976	630.8451002	10646.7389
45	10646.7389	701.33	66.54211789	634.7878821	10011.951
46	10011.951	701.33	62.57469362	638.7553064	9373.19567
47	9373.19567	701.33	58.58247296	642.747527	8730.44815
48	8730.44815	701.33	54.56530091	646.7646991	8083.68345
49	8083.68345	701.33	50.52302155	650.8069785	7432.87647
50	7432.87647	701.33	46.45547793	654.8745221	6778.00195
51	6778.00195	701.33	42.36251217	658.9674878	6119.03446
52	6119.03446	701.33	38.24396537	663.0860346	5455.94842
53	5455.94842	701.33	34.09967765	667.2303223	4788.7181
54	4788.7181	701.33	29.92948814	671.4005119	4117.31759
55	4117.31759	701.33	25.73323494	675.5967651	3441.72082
56	3441.72082	701.33	21.51075516	679.8192448	2761.90158
57	2761.90158	701.33	17.26188488	684.0681151	2077.83346
58	2077.83346	701.33	12.98645916	688.3435408	1389.48992
59	1389.48992	701.33	8.684312026	692.645688	696.844236
60	696.844236	701.33	4.355276476	696.9747235	0

jeff jeffy answered 1 year ago

Next > < Previous

Related Solutions

Wilma borrows $10,000 from “Jaw Breaker Joe” and promises to repay Joe a total of $10,500...

Wilma borrows $10,000 from “Jaw Breaker Joe” and promises to repay Joe a total of $10,500 in one month. What is the effective annual interest rate charged by Joe? A. 5.00% B. 60.00% C. 79.59% D. 179.59%

A person borrows $100,000 at a simple interest rate r = 24%. He is to repay...

A person borrows $100,000 at a simple interest rate r = 24%. He is to repay the loan with 2 payments, one at the end of 2 months and the other at the end of 6 months. The first payment is the same as the 2nd payment. Determine the size of the payments, using the end of 6 months as the focal date.

Robinson borrows a certain amount of money at 7% effective. He will repay this loan by...

Robinson borrows a certain amount of money at 7% effective. He will repay this loan by making payments of 2000 at the end of each year for 15 years, using the amortization method. Calculate the amount of principal repaid in the 4th payment.

If Pete borrows $250 from his sister and promises to pay back the borrowed money and...

If Pete borrows $250 from his sister and promises to pay back the borrowed money and all interest payments in 3 years with annual interest rate of 4.91%. Three years later, how much will Pete need to pay back to his sister? Please round your answer to the second decimal without dollar sign or comma. E.g. 1234.56

Harry borrows $3,500 from Mary. He agrees to repay the loan with annual payments, made at...

Harry borrows $3,500 from Mary. He agrees to repay the loan with annual payments, made at the end of each year, of $500, $1,000, $1,500, etc. with a smaller final payment one year after the last regular payment. Mary charges Henry a rate of discount 10% convertible 4 times per year. Determine the amount of the final payment. Ans: At least $1670, but less than $1700.

Jake owes $3,400 on his credit card. He is not charging any additional purchases because he...

Jake owes $3,400 on his credit card. He is not charging any additional purchases because he wants to get this debt paid in full. The card has an APR of 13.2 percent. How much longer will it take him to pay off this balance if he makes monthly payments of $50 rather than $60?

PART 1 Aunt Esmeralda promises to give her nephew $35,000 on his 30th birthday, 14½ years...

PART 1 Aunt Esmeralda promises to give her nephew $35,000 on his 30th birthday, 14½ years from now. Aunt Esmeralda can earn 5.8% compounded semiannually. What amount could Aunt Esmeralda deposit today in a savings plan so that the plan would have required $35,000 in 14 1/2 years? $6,823.13 $15,453.46 $23,123.05 $15,276.44 PART 2 Refer to Problem 1. If, instead, Aunt Esmeralda elects to make semiannual deposits into the plan (starting in 6 months), what is the required semiannual deposit?...

A person borrows $240 that he must repay in a lump sum no more than 10 years from now.

A person borrows $240 that he must repay in a lump sum no more than 10 years from now. The interest rate is 7.4% annually compounded. The borrower can repay the loan at the end of any earlier year with no prepayment penalty.a. What amount will be due if the borrower repays the loan after 1 year?b. How much would the borrower have to repay after 5 years?c. What amount is due at the end of the tenth year?

Jake routinely directly holds his own stocks. He updates the stocks in his portfolio every week,...

Jake routinely directly holds his own stocks. He updates the stocks in his portfolio every week, trying to pick the stocks that will perform the best over the next week. Jake is managing his assets using ________. an active investing strategy a passive investing a mutual fund a bank Suppose that you own stock in a company that sells flour. If you wanted to diversify to protect your portfolio against the risk that severe flooding might cause crop failure, leading...

In his current job, Jake can work as many hours per day as he chooses and...

In his current job, Jake can work as many hours per day as he chooses and is paid $10 per hours. Faced with this wage schedule, he chooses to work 12 hours per day. A law has just been passed requiring employers to pay double wages for any hours in excess of 8 hours. True/False: Assuming that leisure is a normal good for Jake, he will certainly work more than 12 hours per day. With the use of an appropriate...

Subjects