Logo
Home Study Material Contact Search
AI Chat FREE
  1. business
  2. accounting
  3. b. which of the following is not an...

b. Which of the following is NOT an...

80.2K

Verified Solution

Question

Accounting

image
image
b. Which of the following is NOT an input of the spreadsheet model? Interest rate Monthly mortgage payment Number of years of the loan Annual maintenance cost rate c. What is the monthly total of home ownership using the assumptions stated in the spreadsheet? Note: Round your answer to 2 decimal places. d. How much does the monthly total of home ownership increase if the owner decides to get a 15 -year mortgage instead, of a 30 -year mortgage? Note: Round your answer to 2 decimal places. \begin{tabular}{l|r|r|} \hline 2 & Variables: & \\ \hline 3 & House value: & $576,300.00 \\ 4 & Interest rate: & 4.25% \\ 5 & Down payment (\% of house value): & 20% \\ 6 & Number of years: & 30 \\ 7 & Property tax rate: & 1.25% \\ 8 & Annual homeowner insurance premium: & 1,420.00 \\ \hline 9 & Maintenance cost rate (\% of house value): & 1% \\ 10 & & \\ 11 & Monthly Cost of Home Ownership & \\ 12 & Monthly mortgage payment: & \\ 13 & Monthly property tax: \\ 14 & Monthly homeower insurance premium: \\ 15 & Monthly maintenance costs: : \\ \hline 16 & Total: \\ \hline \end{tabular}

Answer & Explanation Solved by verified expert
Get Answers to Unlimited Questions

Join us to gain access to millions of questions and expert answers. Enjoy exclusive benefits tailored just for you!

Membership Benefits:
  • Unlimited Question Access with detailed Answers
  • Zin AI - 3 Million Words
  • 10 Dall-E 3 Images
  • 20 Plot Generations
  • Conversation with Dialogue Memory
  • No Ads, Ever!
  • Access to Our Best AI Platform: Flex AI - Your personal assistant for all your inquiries!
Become a Member

Other questions asked by students

Statistics
1.2K views

If A B C and D are the only possible outcomes of an experiment find...

Psychology
1.2K views

What is your understanding about Gender Dysphoria and transsexuality? Provide an example of each. Has this...

Psychology
1.2K views

Subject sociology What are the functions of deviance? Give examples

Basic Math
1.2K views

Evaluate the differences between dependent and independent samples. Provide an example of each type of sample.

Basic Math
1.2K views

After specialization suppose that Rob and Big trade with one another and Rob sends Big...

Basic Math
1.2K views

The famous iris dataset (the first sheet of the spreadsheet linked above) was first published...

Calculus
1.2K views

Let h x f x g x If f x 2x 2x 3 and g...

Algebra
1.2K views

Let P 1 3 5 6 u 4 2 1 0 V 1 W W...

Accounting
1.2K views

suponga que la tasa libre de riesgo real es 3.50%, la tasa de inflacin futura...

Accounting
1.2K views

Beginning inventory, purchases, and sales for Item Gidget are as follows: Sept....

Accounting
1.2K views

The current price of a non-dividend paying stock is 50. There is a 3-month forward...

Accounting
1.2K views

Sengupta Company expects to receive $100 at the end of each of the next 3...