Question
In: Finance
7. John and Mary Landlord want to purchase 200 acres of farm land valued at $2,000...
7. John and Mary Landlord want to purchase 200 acres of farm land valued at $2,000 per acre. Their lender requires a 20% down payment. Assume twenty annual payments. The interest rate is 7.0%. [USPV.07,20=10.5940]
a. Calculate the schedule of interest and principal payment over the life of the loan using the constant payment method and the constant payment on principal method. Show your answer using a table. If you choose to use an excel spreadsheet then you need to submit that too. (20 points)
b. What is the total interest paid over the life of the loan with each method?
Solutions
Expert Solution
Please refer to below spreadsheet for calculation and answer. Cell reference also provided.
Cell reference -
jeff jeffy answered 2 years agoRelated Solutions
Suppose a farm couple has the option to purchase 400 acres of land. Assume they are...
Suppose a farm couple has the option to purchase 400 acres of
land. Assume they are able to purchase the land for $4,000/acre.
Assume a 25% down payment with the balance financed by a 30 year
loan with a 7% interest rate and equal annual principal payments.
What will their interest change in year 2 be?
a.
$40,000
b.
$84,000
c.
$78,400
d.
$81,200
Jane and John Boilermaker wish to purchase a 40 acre tract of land valued at $1,900...
Jane and John Boilermaker wish to purchase a 40 acre tract of
land valued at $1,900 per acre. The lender charges a $500 loan
application fee and $250 for a real estate appraisal. Fees totaling
1% of the loan amount are also required to complete the loan. The
fees can be added to the original loan amount. The lender requires
$24,000 initial equity for this loan. The contractual interest rate
is 7%. The fixed annual payments are based on a...
Some time ago, Julie purchased eleven acres of land costing $14,890. Today, that land is valued...
Some time ago, Julie purchased eleven acres of land costing
$14,890. Today, that land is valued at $71,805. How long has she
owned this land if the price of the land has been increasing at 6
percent per year?
27.13 years
26.51 years
27.00 years
26.72 years
26.67 years
John decides to purchase a home from Mary. Mary has John move in, pay $10,000 as...
John decides to purchase a home from Mary. Mary has John move
in, pay $10,000 as a down payment, and John makes payments of $1500
per month, split between principal and interest. This is not put in
writing. John pays the monthly payments for 8 months. Then, in
writing, Mary sells her home to Cynthia, who pays in cash, and
wants to move in. Mary tries to kick John out of the home, saying
that he is only renting and...
You are considering the purchase of 10 acres to plant an apple orchard. The land is...
You are considering the purchase of 10 acres to plant an apple
orchard. The land is priced at $17,500/acre and it will cost
$65,000 to plant the trees and install the irrigation system. Based
on your research, you won't be producing enough apples to sell
until year 5. From then on you estimate your net returns will be
$45,000 a year. If you plan on operating the orchard for 15 years,
what is your NPV? Assume that the land appreciates...
In 1979, Paul and John Reardon purchased 16 acres of land located next to a manufacturing...
In 1979, Paul and John Reardon purchased 16 acres of land
located next to a manufacturing plant in Massachusetts. In 1983, a
state environmental agency, responding to a citizen's report,
tested soil samples from both properties and discovered extremely
high levels of polychlorinated biphenyls (PCBs) on the plant site
and on the Reardons' property where it bordered the site. Shortly
thereafter, the Environmental Protection Agency (EPA) cleaned up
the contaminated areas. In 1985, the EPA notified the Reardons that
they...
Mr. Agirich of Aggie Farms is considering the purchase of 100 acres of prime ranch land...
Mr. Agirich of Aggie Farms is
considering the purchase of 100 acres of prime ranch land that is
adjacent the ranch he now owns. Mr. Agirich can operate the
additional 100 acres with present labor, machinery and breeding
livestock. The land is selling for $400 per acre. Mr.
Agirich believes that the operating receipts per acre of land per
year will $450 and operating expenses will be $420 in present
dollars. Mr. Agirich expects that the inflation rate will be...
Mr. Agirich of Aggie Farms is considering the purchase of 100 acres of prime ranch land...
Mr. Agirich of Aggie Farms is
considering the purchase of 100 acres of prime ranch land that is
adjacent the ranch he now owns. Mr. Agirich can operate the
additional 100 acres with present labor, machinery and breeding
livestock. The land is selling for $400 per acre. Mr.
Agirich believes that the operating receipts per acre of land per
year will $450 and operating expenses will be $420 in present
dollars. Mr. Agirich expects that the inflation rate will be...
1. John Smith, owner of Happy Acres Farm produced young seedless grapes which can be used...
1. John Smith, owner of Happy Acres Farm
produced young seedless grapes which can be used for raisins or
making wine. The bulk of Smith’s crop is contracted at the
beginning of season so John must decide how to allocate his
acreage. Weather conditions after the decision is made are crucial
and difficult to predict. Raisins are sun-dried in the open an
drain during this time can inflict heavy losses. If John decides to
product grapes for wine, rain doesn’t...
You want to purchase agricultural land and enrolling the land in a conservation program offered by...
You want to purchase agricultural land and enrolling the land in
a conservation program offered by your state water and soil
resources board. This program pays landowners not to farm the land
for a specified period of time. A requirement of the program is
that you establish vegetation on the land that would benefit
wildlife. The program provides cost-share funding to help
landowners establish wildlife habitat. Your estimate that the costs
and returns associated with purchasing the land, enrolling it...
ADVERTISEMENT
ADVERTISEMENT
Latest Questions
- #Python: A palindrome is a sequence of characters that reads the same backwards as forwards. For...
- Explain an example in which a variable has two different addresses at different places in a...
- Hadley, a thirty-five-year-old physician, has worked at Princeton Plainsboro Hospital for six years. She recently received...
- QUESTION 1. For each of the following, state whether the occurrence of the variable x occurs...
- According to Mike Taft of RVK, the “Markets Group” is an important unit of the Federal...
- Describe the process of STP from implementation to convergence.
- Convert the following numbers as indicated. Use as few digits in the results as necessary or...
ADVERTISEMENT