Financial Accounting Plus MyLab Accounting with Pearson eText -- Access Card Package (12th Edition)
12th Edition
ISBN: 9780134833132
Author: C. William Thomas, Wendy M. Tietz, Walter T. Harrison Jr.
Publisher: PEARSON
expand_more
expand_more
format_list_bulleted
Concept explainers
Question
Chapter F, Problem F.2S
1.
To determine
The present value of lease if the annual Interest rate In the lease is 18%
2.
To determine
The present value of lease if the car can likely be sold for $6,000 at the end of three years.
Expert Solution & Answer
Want to see the full answer?
Check out a sample textbook solutionStudents have asked these similar questions
A case study analysis of leasing business equipment compared to purchasing the same equipment.How do you determine whether you should lease or buy a piece of equipment for your business? Let's assume you're faced with the following lease-or-buy decision:You can purchase a $50,000 piece of equipment by putting 25 percent down and paying off the balance at 10 percent interest with four annual installments of $11,830. The equipment will be used in your business for eight years, after which it can be sold for scrap for $2,500.The alternative is that you can lease the same equipment for eight years at an annual rent of $8,500, the first payment of which is due on delivery. You'll be responsible for the equipment's maintenance costs during the lease.You expect that your combined federal and state income tax rate will be 40 percent for the entire period at issue. You further assume that your cost of capital is 6 percent (the 10 percent financing rate adjusted by your tax rate).Question:Using…
Find the interest earned on $5,750 deposited into a savings account for 3 1/2 years at an annual interest rate of 4 1/2%
a. What formula should be used?
b. What are you trying to find and what variable does it represent in the formula?
c. Solve the problem showing all of your work (must show all steps!!)
d. Interpet your answer using a complete sentence
You may use the box below to upoload a picture of your written explanation or type it out in the box. Use the "mountain"
button to add pictures.
You are assiting a newly hired employee. You begin explaning the process of utilizing excel to finance properties. Consider the following.
A realator has a house on sale for $640,000. If possible you believe you can finance the home for $300,000 for 20 years at a 3% interest rate. What would the monthly principle and interest payment be for the acquird loan?
Calculate using the PV funtion in excel.
How would you caluclate this in Excel using the PV function?
Rate:
Nper:
Pmt:
FV:
Type:
Chapter F Solutions
Financial Accounting Plus MyLab Accounting with Pearson eText -- Access Card Package (12th Edition)
Knowledge Booster
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, accounting and related others by exploring similar questions and additional content below.Similar questions
- Jill is leasing a $32,000 car for $599/month for three years. In three years, she expects to buy it outright for $16,000 at the same time she makes her last lease payment. If it costs her 5.5% to borrow, what is the implicit rate in the lease? Should she lease or borrow the money to get the car? (Hint: use the IRR function). B. C D F G Problem 1 Start Mo. 1 Мо. 2 Мо. 3 Мо. 4 Mo. 5 Мо. 6 Мо. 7 Cash flows (37,564) 599 599 599 599 599 599 599 Borrowing cost Implicit lease cost 5.5%arrow_forwardPerformance task No.2: SIMPLE INTERESTS Directions: Complete the table below. Show your solution on a separate sheet. 1. Find the simple interest on a loan of P65,000 if the loan is given at a rate of20% and is due in 3 years. 2. Amparo invested a certain amount at 10% simple interest per year. After 2years, the interest she received amounted to P3,000. How much did she invest? 3. Miko borrowed P25,000 at 10% annual simple interest rate. How much should he pay after 3 years and 6 months?arrow_forwardPlease solve using excel and please explaing the steps to find out the best choice for each market condition listed below (choices a, b, and c) You decide to buy a house of $250,000 with loan amount of $200,000 and you plan to sell the house in year 10. The lender offers the following three SAM choices with $5,000 origination cost for each choice: $200,000; 30 years; monthly payment; 0% interest rate; 50% of appreciated value of the property in year 10. In addition, if the property is sold for a loss in year 10, the lender pays nothing. $200,000; 30 years; monthly payment; 3% interest rate; 50% of appreciated value of the property in year 10 $200,000; 30 years; monthly payment; 5% interest rate; 25% of appreciated value of the property in year 10 The housing market conditions: a. Home price will appreciate 30% in total for the next 10 years; b. Home price will stay the same for the next 10 years c. Home price will decline 30% in total for the next 10 years.arrow_forward
- Assume you are preparing to move into a new neighborhood. You are considering renting or buying. Divide your team into two groups. Requirements Group 1 will analyze the renting option. A suitable rental is available for $500 per month, and you expect rent to increase by $50 per month per year. Prepare a schedule showing rent payments for the next 15 years. To simplify the problem, assume rent is paid annually. Using 5% as the discount rate, determine the present value of the rent payments. Round present value amounts to the nearest dollar. Group 2 will analyze the buying option. A suitable purchase will require financing $105,876 at 5%. Annual payments for 15 years will be $10,200 (annual payments assumed to simplify the problem). Calculate the present value of the payments. Additionally, using Excel with appropriate formulas, prepare a payment schedule with the following columns (year 1 is completed as an example): After each group has prepared its schedule, meet as a full team to…arrow_forwardAlternative Calculation of Monthly Lease Payment: FV PV (1+ i)N 1 LP = 1 (1+i)N-A i + A where LP – monthly lease payment; PV – the present value of the future payments on the lease, including the residual value, i.e. it is a lease amount; FV – the future value of leased asset or its residual value; N- the lease term (number of months); A - the number of payments to be paid in advance (0,1,2,...); i- monthly interest rate (i = APR÷12). The formula presented above can be used for any payment frequency. Just be sure that N is the number of periods and į is the interest rate per period.arrow_forwardYou are interested in leasing a car for $425 per month, due at the beginning of each month. Using an interest rate of 4% annually, what is the present worth of a one-year lease for this car? a) Slove using Annual Worth b) Solve using Internal Rate of Return Excel is preferredarrow_forward
- An investor is looking for a loan for an investment property that he has found. He can afford a monthly payment of $1,475. The interest rated quoted to him was 7.25%. He built the following table from that information. A $74,049 $125,638 $161,580 t 5 10 15 a) A(5) = b) If the investment property cost $161,580, how many years must the investor make monthly payments? t 20 25 30 A $186,620 $204,066 $216,220arrow_forwardYou just borrowed $490,000 for a mortgage on your new home. The mortgage has a 30-year term with monthly payments and an APR of 6.96%. a. How much will you pay in interest, and how much will you pay in principal, during the first year? Question content area bottom Part 1 a. How much will you pay in interest, and how much will you pay in principal, during the first year? Principal: $enter your response here. (Round to the nearest dollar.) Interest: $enter your response here. (Round to the nearest dollar.)arrow_forwardYou plan to purchase a $240,000 house using a 30-year mortgage obtained from your local credit union. The mortgage rate offered to you is 8 percent. You will make a down payment of 10 percent of the purchase price. a. Calculate your monthly payments on this mortgage. b. Construct the amortization schedule for the first six payments. Complete this question by entering your answers in the tabs below. Required A Required B Construct the amortization schedule for the first six payments. (Do not round intermediate calculations. Round your answers to 2 decimal places. (e.g., 32.16)) Amortization Schedule for first 6 payments (months) Month Beginning Loan Balance Payment Interest Principal Ending Loan Balance 1 2 3 4 5 6arrow_forward
- Assume a 20-year, 8%, monthly amortizing, $4,000,000 mortgage on a residential property that was purchased for $5,000,000. Net operating income for Year 1 is $400,000. You can easily do these problems in Excel, and some with an online mortgage calculator, but you'll need to be able to do them using your calculator for Exam 4, so you might want to practice. For all answers, round to the nearest dollar (e.g., 423,444). See inclass 11/14/23 answers (page 5 for calculator instructions). What is the total mortgage payment in Year 1 (not the monthly amount)? What is the total amount paid in interest in Year 1? What is the mortgage balance at the end of Year 1? What is the annual depreciation amount? What would be the Year 1 pre-tax cash flow, taking the answers above into account? Assuming a 20% tax rate, what would be the taxes paid for Year 1? Assuming the foregoing information, what would be the after-tax cash flow for Year 1?arrow_forwardSuppose you are a relationship manager at an international bank. A customer who recently got admission at a prestigious Business School approached you for an education loan of Rs. 36,00,000. Your bank offers the education loan at 9.6 percent to be repaid in 10 years in EMIs. You are assigned the task of preparing the amortization schedule for the customer and answer the following. Prepare the amortization schedule for the first 5 EMIs. What will be interest paid for 93th EMI? What will be the loan balance after 93th EMI? What is the total interest paid for the loan?arrow_forwardConstruct the amortization schedule for a $8000 debt that is to be amortized in 6 equal quarterly payments at 2% interest per quarter on the unpaid balance. How much interest must be paid? After you are ready, choose the "Finish attempt" option, and then "Submit all and finish". After this, take a picture or scan your solution and upload it into the e-learning system. You should upload the solution in jpg or pdf format. Please, write legibly. If I can not read your solution, I can not give points either.arrow_forward
arrow_back_ios
SEE MORE QUESTIONS
arrow_forward_ios
Recommended textbooks for you
- AccountingAccountingISBN:9781337272094Author:WARREN, Carl S., Reeve, James M., Duchac, Jonathan E.Publisher:Cengage Learning,Accounting Information SystemsAccountingISBN:9781337619202Author:Hall, James A.Publisher:Cengage Learning,
- Horngren's Cost Accounting: A Managerial Emphasis...AccountingISBN:9780134475585Author:Srikant M. Datar, Madhav V. RajanPublisher:PEARSONIntermediate AccountingAccountingISBN:9781259722660Author:J. David Spiceland, Mark W. Nelson, Wayne M ThomasPublisher:McGraw-Hill EducationFinancial and Managerial AccountingAccountingISBN:9781259726705Author:John J Wild, Ken W. Shaw, Barbara Chiappetta Fundamental Accounting PrinciplesPublisher:McGraw-Hill Education
Accounting
Accounting
ISBN:9781337272094
Author:WARREN, Carl S., Reeve, James M., Duchac, Jonathan E.
Publisher:Cengage Learning,
Accounting Information Systems
Accounting
ISBN:9781337619202
Author:Hall, James A.
Publisher:Cengage Learning,
Horngren's Cost Accounting: A Managerial Emphasis...
Accounting
ISBN:9780134475585
Author:Srikant M. Datar, Madhav V. Rajan
Publisher:PEARSON
Intermediate Accounting
Accounting
ISBN:9781259722660
Author:J. David Spiceland, Mark W. Nelson, Wayne M Thomas
Publisher:McGraw-Hill Education
Financial and Managerial Accounting
Accounting
ISBN:9781259726705
Author:John J Wild, Ken W. Shaw, Barbara Chiappetta Fundamental Accounting Principles
Publisher:McGraw-Hill Education
Capital Budgeting Introduction & Calculations Step-by-Step -PV, FV, NPV, IRR, Payback, Simple R of R; Author: Accounting Step by Step;https://www.youtube.com/watch?v=hyBw-NnAkHY;License: Standard Youtube License