Suppose you have decided to purchase an automobile. You analyze your personal budget and decide you...

Suppose you have decided to purchase an automobile. You analyze your personal budget and decide you can afford monthly payments of $506 for five years. If your loan carries an annual interest rate of 12%, what the highest priced car you can afford?

a. Excel command ____________

b. answer ____________

Expert Solution

ekkarill92 answered 2 years ago

Imagine that you have decided to acquire your dream car. You now have to decide whether to...

Imagine that you have decided to acquire your dream car. You now have to decide whether to buy or lease that car. Write a report specifying the differences between leasing and buying your dream car and make a decision on whether to buy or lease. In writing your report you must do the following: Gather the terms under which you would lease the car, such as the necessary down payment amount and monthly payment amount. Calculate the total costs when leasing...

Suppose you purchase a $300,000 condominium for your personal residence putting down

Suppose you purchase a $300,000 condominium for your personal residence putting down 3% and borrowing the balance at a rate of 3.5% for 30 years. If you move in on July 1 of 2021, approximately how much of a tax deduction can you take for the tax year 2021 assuming you itemize your deductions and are not subject to any SALT limits? How does this change the after-tax cost of your mortgage? Show all calculations.Consider a 4-unit residential property for...

Congratulations! You have decided to leave your career as a personal tax accountant to pursue a...

Congratulations! You have decided to leave your career as a personal tax accountant to pursue a startup idea you have been thinking about for a long time. You are going to launch a new app that tracks all of your personal tax information throughout the year, so that you don’t have to load anything come tax time. You want this app to fully integrate with users payroll, investment accounts, and any other system that creates tax liability. You have validated...

You and your lovely and/or handsome spouse have decided the purchase a new home with a...

You and your lovely and/or handsome spouse have decided the purchase a new home with a loan for $260,000. The mortgage you chose offers a contract rate of 4.5%, a maturity of 30 years, and requires the payment of 3 points. What is the annual effective cost of borrowing for this loan if you make your scheduled payments for the full 30 years?

Suppose you decide to purchase a $150,000 home using an inheritance of $20,000 as your down...

Suppose you decide to purchase a $150,000 home using an inheritance of $20,000 as your down payment. A down payment is subtracted from the total cost of the home and therefore you owe $130,000. To pay for this amount you will need a loan, so $130,000 is the principal on your loan. Suppose the interest rate on a 30 year mortgage is 4.75%. What will your monthly payment be? How much will you pay on the loan if you pay...

Suppose that you have decided to purchase a house for $400,000 using an adjustable-rate mortgage with...

Suppose that you have decided to purchase a house for $400,000 using an adjustable-rate mortgage with the terms provided below. Loan-to-value ratio: 90% Index rate: one-year Treasury yield (currently 3.00%) Margin: 250 basis points Amortization: 15 years with monthly payments and compounding Annual cap: 1.5 percentage points Lifetime cap: 5 percentage points Adjustment period: Annually Teaser Rate 2.50% What is the monthly payment during the first year of the loan? a. $2400.44,b. $2133.73,c. $3268.33, d. $2667.16, e. None of the...

Since you are a mechanical Engineer, suppose that you decided to establish a Typical Automobile maintenance...

Since you are a mechanical Engineer, suppose that you decided to establish a Typical Automobile maintenance center: Any missing information please suggest it from your own the following data is an assumption from me. for more info I will add the original question below (but please neglect it) The project life considered to be 10 years since the automobiles lifecycle is around 10 years and after the 10 years all the equipment of the maintenance center should be updated (new...

This is a Personal Budget: At the beginning of the school year, Craig Kovar decided to...

This is a Personal Budget: At the beginning of the school year, Craig Kovar decided to prepare a cash budget for the months of September, October, November, and December. The budget must plan for enough cash on December 31 to pay the spring semester tuition, which is the same as the fall tuition. The following information relates to the budget: Cash balance, September 1 (from a summer job) $7,630 Purchase season football tickets in September 100 Additional entertainment for each...

suppose you took out a fully amortized $30,000 automobile loan to finance your purchase over 48...

suppose you took out a fully amortized $30,000 automobile loan to finance your purchase over 48 months at an APR of 3.5%. So far, you have made two years of payments in a timely fashion so the next payment will be your 25th. what percentage of the next payment will be allocated toward reducing the outstanding balance on the loan and what percentage will be interest?

Payback Period and NPV of Alternative Automobile Purchase Wendy Li decided to purchase a new Honda...

Payback Period and NPV of Alternative Automobile Purchase Wendy Li decided to purchase a new Honda Civic. Being concerned about environmental issues she is leaning toward a Honda Civic Hybrid rather than the completely gasoline-powered LX model. Nevertheless, she wants to determine if there is an economic justification for purchasing the Hybrid, which costs $3,700 more than the LX. Based on a mix of city and highway driving she predicts that the average gas mileage of each car is 40...

Question