You purchase a plot of land worth $58,000 to create a community garden. To do so, you secure a 10-year loan, charging 5.11% APR, compounded monthly, and requiring monthly payments of $505. (Assume the value of the land is still $58,000. Round each answer to the nearest dollar.) (a) Assuming that you put some money down, what was your original loan amount (in dollars)? (b) What is the outstanding balance (in dollars) on your loan after making 4 years of payments? $ (c) How much equity (in dollars) do you have in the garden after 4 years?

You want to investigate whether it will make financial sense for your business to purchase some real estate. Find a commercial property that is for sale in Charlotte, NC that your business could use (purchase price must be at least $20,000). Include the URL that will take the class to the webpage for the property.   You will finance 80% of the purchase price; you will put 20% down on the purchase. Using 5% as the interest on your 30-year fixed rate mortgage, calculate the monthly payment.   Next, calculate the payment using the same 5%, but for a 15-year mortgage. Show all steps in your calculations in your post.   In a summary paragraph, discuss the results of your calculations and what you think is the best decision for your business to make regarding purchasing the property.   Include these items in your post:   URL link to property Calculation of 30-year monthly payment Calculation of 15-year monthly payment Steps in calculations (Excel is recommended) Summary

How would I input this information into excel?

You’re considering purchasing an apartment for $200,000. You believe that you can earn an initial rental income of $12,000 per year on it and that the rental income will grow at 3% per year. You also believe that you can sell the apartment for $225,000 after 5 years. The IRR calculation is shown below:

You purchase a plot of land worth $54,000 to create a community garden. To do so, you secure a 10-year loan, charging 5.22% APR, compounded monthly, and requiring monthly payments of $505. (Assume the value of the land is still $54,000. Round each answer to the nearest dollar.) (a) Assuming that you put some money down, what was your original loan amount (in dollars)? X $ (b) What is the outstanding balance (in dollars) on your loan after making 4 years of payments? $ 170255.84 (c) How much equity (in dollars) do you have in the garden after 4 years? $ X

Susan would like to buy a car. She went to the bank and got a loan for $40,000 at the annual interest rate of 4%, for 4 years. Calculate the monthly payment. Calculate the interest on the payment. Calculate the total payment. Make complete amortization schedule on excel

Calculate how much money a prospective homeowner would need for closing costs on a house that costs $190,000. Calculate based on a 15 percent down payment, 1.3 discount points on the loan, a 1.2 point origination fee, and $820 in other fees. The closing costs would be $. (Round to the nearest dollar.)

what would the formula be to solve for the table value? the table value is what i need to solve the problem

A computer chip designer purchased a car for $59,476.47, which includes sales tax and registration. The designer obtains a 5-year loan for the total amount at an annual interest rate of 6.3% compounded monthly. The designer will make monthly payments. The payments calculation for this type of loan uses the formula for the present value of which type of annuity? Given the formula for the payment amount of annuity where PMT is the payment amount in dollars, PV is the present value in dollars, n is the number of payments, and i is the interest rate per period. PMT= ? Determin the following values. PV= $ n= i= What is the designer’s monthly payment? (Round your answer to the nearest cent.)

A new homeowner is purchasing a living room set for $2,590 and must decide between two monthly installment financing offers.Offer 1: $200 down payment, remaining balanced financed at a 24.90% interest rate for 3 years.Offer 2: $425 down payment, remaining balanced financed at a 22.90% interest rate for 4 years.Part A: What is the total cost of offer 1? Explain which technology you used to solve and each step of your process. Part B: What is the total cost of offer 2? Explain which technology you used to solve and each step of your process.Part C: Which financing offer should the new homeowner choose?