Question
In: Finance
Find the monthly payment and estimate the remaining balance(to the nearest dollar). Assume interest is on...
Find the monthly payment and estimate the remaining balance(to the nearest dollar). Assume interest is on the unpaid balance.
30-year car loan for $235,000 at 3.21%; remaining balance after 20 years.
Solutions
Expert Solution
MONTHLY PAYMENTS = 1017.58
| P = | Regular Payments | |||
| PV = | Loan Amount | |||
| r = | rate of interest | |||
| n = | no of periods | |||
| P = | r (PV) | |||
| 1 - (1 + r )-n | ||||
| P = | (3.21%/12)*235000 | |||
| 1 - (1 / (1 + 3.21%/12)^360)) | ||||
| P = | 628.625 | |||
| 0.617762937 | ||||
| P = | 1017.58 | |||
| BALANCE AFTER 20 YEARS (240 EMI) = | $104,332.03 | |||
| Beginning Balance | Interest | Principal | Ending Balance | |
| 1 | $235,000.00 | $628.63 | $388.96 | $234,611.04 |
| 2 | $234,611.04 | $627.58 | $390.00 | $234,221.04 |
| 3 | $234,221.04 | $626.54 | $391.04 | $233,830.00 |
| 4 | $233,830.00 | $625.50 | $392.09 | $233,437.91 |
| 5 | $233,437.91 | $624.45 | $393.14 | $233,044.78 |
| 6 | $233,044.78 | $623.39 | $394.19 | $232,650.59 |
| 7 | $232,650.59 | $622.34 | $395.24 | $232,255.35 |
| 8 | $232,255.35 | $621.28 | $396.30 | $231,859.05 |
| 9 | $231,859.05 | $620.22 | $397.36 | $231,461.69 |
| 10 | $231,461.69 | $619.16 | $398.42 | $231,063.26 |
| 11 | $231,063.26 | $618.09 | $399.49 | $230,663.78 |
| 12 | $230,663.78 | $617.03 | $400.56 | $230,263.22 |
| Year #1 End | ||||
| 13 | $230,263.22 | $615.95 | $401.63 | $229,861.59 |
| 14 | $229,861.59 | $614.88 | $402.70 | $229,458.89 |
| 15 | $229,458.89 | $613.80 | $403.78 | $229,055.11 |
| 16 | $229,055.11 | $612.72 | $404.86 | $228,650.25 |
| 17 | $228,650.25 | $611.64 | $405.94 | $228,244.30 |
| 18 | $228,244.30 | $610.55 | $407.03 | $227,837.27 |
| 19 | $227,837.27 | $609.46 | $408.12 | $227,429.15 |
| 20 | $227,429.15 | $608.37 | $409.21 | $227,019.94 |
| 21 | $227,019.94 | $607.28 | $410.30 | $226,609.64 |
| 22 | $226,609.64 | $606.18 | $411.40 | $226,198.24 |
| 23 | $226,198.24 | $605.08 | $412.50 | $225,785.74 |
| 24 | $225,785.74 | $603.98 | $413.61 | $225,372.13 |
| Year #2 End | ||||
| 25 | $225,372.13 | $602.87 | $414.71 | $224,957.42 |
| 26 | $224,957.42 | $601.76 | $415.82 | $224,541.60 |
| 27 | $224,541.60 | $600.65 | $416.93 | $224,124.66 |
| 28 | $224,124.66 | $599.53 | $418.05 | $223,706.61 |
| 29 | $223,706.61 | $598.42 | $419.17 | $223,287.44 |
| 30 | $223,287.44 | $597.29 | $420.29 | $222,867.16 |
| 31 | $222,867.16 | $596.17 | $421.41 | $222,445.74 |
| 32 | $222,445.74 | $595.04 | $422.54 | $222,023.20 |
| 33 | $222,023.20 | $593.91 | $423.67 | $221,599.53 |
| 34 | $221,599.53 | $592.78 | $424.80 | $221,174.73 |
| 35 | $221,174.73 | $591.64 | $425.94 | $220,748.79 |
| 36 | $220,748.79 | $590.50 | $427.08 | $220,321.71 |
| Year #3 End | ||||
| 37 | $220,321.71 | $589.36 | $428.22 | $219,893.48 |
| 38 | $219,893.48 | $588.22 | $429.37 | $219,464.12 |
| 39 | $219,464.12 | $587.07 | $430.52 | $219,033.60 |
| 40 | $219,033.60 | $585.91 | $431.67 | $218,601.93 |
| 41 | $218,601.93 | $584.76 | $432.82 | $218,169.11 |
| 42 | $218,169.11 | $583.60 | $433.98 | $217,735.13 |
| 43 | $217,735.13 | $582.44 | $435.14 | $217,299.99 |
| 44 | $217,299.99 | $581.28 | $436.31 | $216,863.68 |
| 45 | $216,863.68 | $580.11 | $437.47 | $216,426.21 |
| 46 | $216,426.21 | $578.94 | $438.64 | $215,987.57 |
| 47 | $215,987.57 | $577.77 | $439.82 | $215,547.75 |
| 48 | $215,547.75 | $576.59 | $440.99 | $215,106.76 |
| 217 | $121,476.75 | $324.95 | $692.63 | $120,784.12 |
| 218 | $120,784.12 | $323.10 | $694.49 | $120,089.64 |
| 219 | $120,089.64 | $321.24 | $696.34 | $119,393.29 |
| 220 | $119,393.29 | $319.38 | $698.21 | $118,695.09 |
| 221 | $118,695.09 | $317.51 | $700.07 | $117,995.01 |
| 222 | $117,995.01 | $315.64 | $701.95 | $117,293.07 |
| 223 | $117,293.07 | $313.76 | $703.82 | $116,589.24 |
| 224 | $116,589.24 | $311.88 | $705.71 | $115,883.54 |
| 225 | $115,883.54 | $309.99 | $707.59 | $115,175.94 |
| 226 | $115,175.94 | $308.10 | $709.49 | $114,466.45 |
| 227 | $114,466.45 | $306.20 | $711.39 | $113,755.07 |
| 228 | $113,755.07 | $304.29 | $713.29 | $113,041.78 |
| Year #19 End | ||||
| 229 | $113,041.78 | $302.39 | $715.20 | $112,326.59 |
| 230 | $112,326.59 | $300.47 | $717.11 | $111,609.48 |
| 231 | $111,609.48 | $298.56 | $719.03 | $110,890.45 |
| 232 | $110,890.45 | $296.63 | $720.95 | $110,169.50 |
| 233 | $110,169.50 | $294.70 | $722.88 | $109,446.62 |
| 234 | $109,446.62 | $292.77 | $724.81 | $108,721.80 |
| 235 | $108,721.80 | $290.83 | $726.75 | $107,995.05 |
| 236 | $107,995.05 | $288.89 | $728.70 | $107,266.36 |
| 237 | $107,266.36 | $286.94 | $730.65 | $106,535.71 |
| 238 | $106,535.71 | $284.98 | $732.60 | $105,803.11 |
| 239 | $105,803.11 | $283.02 | $734.56 | $105,068.55 |
| 240 | $105,068.55 | $281.06 | $736.52 | $104,332.03 |
| Year #20 End | ||
jeff jeffy answered 1 year agoRelated Solutions
Find the monthly payment and estimate the remaining balance. Assume interest is on the unpaid balance....
Find the monthly payment and estimate the remaining balance.
Assume interest is on the unpaid balance.
5-year computer loan for $2483 at 6.7%; remaining balance
after 2 years.
The monthly payment is $
USING MATLAB: A simple mortgage calculator that will output the monthly payment, the remaining balance, and...
USING MATLAB:
A simple mortgage calculator that will output the monthly
payment, the remaining balance, and so on.
years=30;
annual_rate=0.04; % 2.75% annual rate
house_value=500,000;
downpayment=3.5; % 25% down
and plot results
How much interest (to the nearest dollar) would be saved on the following loan if the...
How much interest (to the nearest dollar) would be saved on the
following loan if the condominium were financed for 15 rather than
30 years? A $251,000 condominium bought with a 30% down payment and
the balance financed for 30 years at 3.05%
How much interest (to the nearest dollar) would be saved on the following loan if the...
How much interest (to the nearest dollar) would be saved on the
following loan if the condominium were financed for 15 rather than
30 years? A $269,000 condominium bought with a 30% down payment and
the balance financed for 30 years at 3.05%
How much interest (to the nearest dollar) would be saved on the following loan if the...
How much interest (to the nearest dollar) would be saved on the
following loan if the home were financed for 15 rather than 30
years? A $518,000 home bought with a 20% down payment and the
balance financed for 30 years at 5.4%
Please round to the nearest cent for all answers. --------------------------------------------------------------------------------- Compare the monthly payment and total...
Please round to the nearest cent for all
answers.
---------------------------------------------------------------------------------
Compare the monthly payment and total payment for the following
pairs of loan options. Assume that both loans are fixed rate and
have the same closing costs.
You need a $160,000 loan.
Option 1: a 30-year loan at an APR of 7.25%.
Option 2: a 15-year loan at an APR of 6.8%.
----------------------------------------------------------------
Find the monthly payment for each option.
The monthly payment for option 1
iswhat.
The monthly payment...
Find the monthly payment needed to amortize principal and interest for each fixed-rate mortgage for a...
Find the monthly payment needed to amortize principal and
interest for each fixed-rate mortgage for a $220,000 at 4.5%
interest for 30 years.
Find the monthly payment for a 25-year fixed-rate loan of $200,000 at 5% annual interest.
Find the monthly payment for a 25-year fixed-rate loan of
$200,000 at 5% annual interest.
Exercise 8-31 Algo The monthly closing stock prices (rounded to the nearest dollar) for Panera Bread...
Exercise 8-31 Algo The monthly closing stock prices (rounded to
the nearest dollar) for Panera Bread Co. for the first six months
of 2010 are reported in the following table. [You may find it
useful to reference the t table.] Months Closing Stock Price
January 145 February 144 March 149 April 146 May 150 June 140
Source: http://finance.yahoo.com.
a. Calculate the sample mean and the sample standard deviation.
(Round intermediate calculations to at least 4 decimal places and
"Sample mean"...
Find the final amount (rounded to the nearest dollar) in the retirement account where $1000 per...
Find the final amount (rounded to the nearest dollar) in the
retirement account where $1000 per quarter is invested at 4.2%,
compounded quarterly, for 10 years; then while that money is
accumulating interest in the new account, a new retirement account
is started where $1500 per quarter is invested at 7.4%, compounded
quarterly, for 15 years.
ADVERTISEMENT
ADVERTISEMENT
Latest Questions
- Joni is a financial planner for ABC firm. She provided all of her clients with the...
- Suppose you plan to retire in 40 years. If you make 10 annual investments of $...
- PLEASE DONT FORGET TO SOLVE THE ASSIGNMENT QUESTION MOST IMP: Ex1) Download the code from the...
- Customer is saying website is running slow when his end clients are trying to access the...
- Note: The answers to the following questions should be typed in the block of comments in...
- Python Describe the procedure for setting up the display of an image in a window.
- what are the fundamental similarity and differences between gap and dgap?
ADVERTISEMENT