Question
In: Finance
SHOW YOUR WORK not only the solutions, on worksheet tab in Excel file A fully amortizing...
SHOW YOUR WORK not only the solutions, on worksheet tab in Excel file
A fully amortizing mortgage loan is made for $80,000 at 6 percent interest for 25 years. Payments are to be made monthly.
Calculate:
a. Monthly payments.
b. Interest and principal payments during month 1.
c. Total principal and total interest paid over 25 years.
d. The outstanding loan balance if the loan is repaid at the end of year 10.
e. Total monthly interest and principal payments through year 10.
f. What would the breakdown of interest and principal be during month 50?
Solutions
Expert Solution
|
jeff jeffy answered 2 years agoRelated Solutions
SHOW CLEAR WORK ON EXCEL A fully amortizing mortgage loan is made for $100,000 at 6...
SHOW CLEAR WORK ON EXCEL
A fully amortizing mortgage loan is made for $100,000 at 6
percent interest for 30 years. Determine payments for each of the
periods a–d below if interest is accured:
a. Monthly.
b. Quarterly.
c. Annually.
d. Weekly.
SHOW CLEAR WORK ON EXCEL A 30-year fully amortizing mortgage loan was made 10 years ago...
SHOW CLEAR WORK ON EXCEL
A 30-year fully amortizing mortgage loan was made 10 years ago
for $75,000 at 6 percent interest. The borrower would like to
prepay the mortgage balance by $10,000.
a.
Assuminghecanreducehismonthlymortgagepayments,whatisthenewmortgagepayment?
b. Assuming the loan maturity is shortened and using the
original monthly payments, what is the new loan maturity?
Using the data provided in the excel file, show all of your work for the following...
Using the data provided in the excel file, show all of your work
for the following calculations:
a.) mean temperature of unmixed reagents (oC)
b.) δελταT from graph (oC)
c.) q absorbed by reaction mixture (J)
d.) q absorbed by calorimeter, stirrer, and thermometer (J)
e.) q total absorbed (J)
f.) q total released (J)
g.) calculation to show limiting reagent
h.) deltaH neutralization for the reaction (kJ/mole of acid)
A student reacted
100.0 mL of 0.9800 M HCl with...
Complete the questions below. Submit only an Excel spreadsheet with your name, one tab for each...
Complete the questions below. Submit only an Excel spreadsheet
with your name, one tab for each question, and your Excel Solver
solution; ensure that you clearly identify each answer.
A local pastry shop is planning their next morning’s production.
The shop has three main items that they sell: cakes, cupcakes, and
cannolis. All of these are made in-house with the shop’s own
ingredients. The recipes for these items are as follows:
Cakes: 5 eggs, 2 cups flower, 15 g of...
What are the major differences between the four CPM loans: Fully Amortizing: Partially Amortizing: Interest Only:...
What are the major differences between the four CPM loans:
Fully Amortizing:
Partially Amortizing:
Interest Only:
Negative Amortizing:
Using the data in the Excel file under the tab Problem1, develop a regression equation for...
Using the data in the Excel file under the tab Problem1, develop
a regression equation for a country’s lung cancer death rate based
on cigarette consumption.
Is this a good regression model? Why or why
not?
If Cigarette Consumption was 725, what would you predict the
Lung Cancer Death Rate to be?
Using your regression model, what is the Residual Value for
Finland?
Do you think there are any outliers in the model? If
so, what would you do with them?
Country...
In the Excel data file, the tab labeled Question 1 contains data on the number of...
In the Excel data file, the tab labeled Question 1
contains data on the number of times boys and girls raise their
hands in class. Conduct the t-test: Two-Sample Assuming
Equal Variances.
Males 9,8,4,9,3,8,10,8,9,10,7,6,12
Females 3,5,1,2,6,4,3,6,7,9,7,3,7,6,8,8
a. What is the null hypothesis?
b. What is the research hypothesis?
c. Why run a Two-Sample Assuming Equal Variances
t-test?
d. Interpret the findings. What are the results of the
hypothesis test? Can you reject the null hypothesis?
Please show all work in order to get credit on an excel file. If you provide...
Please show all work in order to get credit on an excel file. If
you provide only the answers without showing your work, I will not
be able to provide any credit if your answer is wrong.
Petrus has an opportunity to make two investments, but he can
only afford to make one of them. Each one costs $ 25,000,000. The
first investment can be sold in 14 years for $ 98,500,000 and has
no periodic cash flow. The second...
Please show all work in order to get credit on an excel file. If you provide...
Please show all work in order to get credit on an excel file. If
you provide only the answers without showing your work, I will not
be able to provide any credit if your answer is wrong.
Mr. X bought a house for $293,000. He put 20% down and obtained
a fully amortized monthly loan for the balance at 5.75% interest
for 30 years.
a. Find the amount of X’s monthly payment.
b. Find the total interest paid by X....
Use Excel to show your work and include the formula in the cell to show how...
Use Excel to show your work and include the formula
in the cell to show how you arrived at your figures. Round
percentages (example if 49.2, round to 49).
Background:
ABC, Inc., produces widgets. The company manufactures three
levels of widgets-Economy, Better and Best. Selected information on
the widgets is given below.
Economy
Better
Best
Selling price per widget
$40.00
$60.00
$90.00
Variable expense per widget production
$22.00
$27.00
$31.50
Selling (5% of selling price)
$2.00
$3.00
$4.50
All sales...
ADVERTISEMENT
ADVERTISEMENT
Latest Questions
- I need this written in Java, it is a Linked List and each of it's Methods....
- A 200 Ω resistor is in series with a 8.50×10−2 H inductor and a 0.540 μF...
- (C++)Radix Sort: Write C++ codes for radix sort: use counting sort for decimal digits from the...
- Write a program, called NationalTax, that will simulate calculating a citizen's income tax for the year....
- Part 1: Write a program that finds the sum and average of a series of numbers...
- Which stock, A or B, or both of them, is preferable to add to the diversified...
- c++ You will implement a template class with the following members: An array of our generic...
ADVERTISEMENT