annual loan payment, using function wizard for PMT.
Not what you're looking for?
With the following information determine the annual loan payment, using function wizard for PMT.
Invoice Price $250,000
Length of loan 4
Loan Interest rate 10%
Maintenance fee $20,000
Tax Rate 40%
Lease fee $70,000
Equipment expected life 8
Expected Salvage value 0
Market value after 4 yrs $42,500
Book value after 4 yrs $42,500
Purchase this Solution
Solution Summary
I have created a model in excel that you can use to solve for any annual payment. You can change the years, rate or price and the payment amount will update.
Education
- BSc, University of Virginia
- MSc, University of Virginia
- PhD, Georgia State University
Recent Feedback
- "hey just wanted to know if you used 0% for the risk free rate and if you didn't if you could adjust it please and thank you "
- "Thank, this is more clear to me now."
- "Awesome job! "
- "ty"
- "Great Analysis, thank you so much"
Purchase this Solution
Free BrainMass Quizzes
Employee Orientation
Test your knowledge of employee orientation with this fun and informative quiz. This quiz is meant for beginner and advanced students as well as professionals already working in the HR field.
Accounting: Statement of Cash flows
This quiz tests your knowledge of the components of the statements of cash flows and the methods used to determine cash flows.
Marketing Research and Forecasting
The following quiz will assess your ability to identify steps in the marketing research process. Understanding this information will provide fundamental knowledge related to marketing research.
Motivation
This tests some key elements of major motivation theories.
Understanding Management
This quiz will help you understand the dimensions of employee diversity as well as how to manage a culturally diverse workforce.