Your client is the CEO of a high tech business and she requires a new car....
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
Your client is the CEO of a high tech business and she requires a new car. She has hired your brokerage company to find suitable transportation for business. She entertains and meets with many foreign business people so company image is important. She will use a company chauffer. Provide your client with 3 different car model options. You select the recommended car for the client. 1. You determine the down payment. 2. Determine what your bank loan will be. 3. Calculate the interest rate and make sure the Rate is described and displayed when you format your assignment. DO NOT USE an Internet purchase calculator. This MUST be calculated in Excel. 4. Calculate what you monthly payment would be if the loan was amortized over the following terms. a. 2.5 years b. 5 ye I c. 8 years 5. You must display all (Monthly) Calculations in your workbook. 6. Provide 3 different car options to your client to select from. 7. You can use the same Rate for all 3 car calculations. 8. Use the bank's prime rate of 4.25% as your base Prime Rate. Add 1.55% to the Bank's Prime rate to determine the consumer loan Interest Rate. 9. Provide 3 various down payment options. 10. From the 3 possible cars you have provided for your client you are to select one of them as your recommendation. Insert a photograph of the recommended car purchase into your client Excel presentation sheets. 11. Provide a brief description of the car. 12. Invoice this client just for your services. 13. Use an Excel Invoice Template "Simple Invoice" included in the Moodle File to bill your Your client is the CEO of a high tech business and she requires a new car. She has hired your brokerage company to find suitable transportation for business. She entertains and meets with many foreign business people so company image is important. She will use a company chauffer. Provide your client with 3 different car model options. You select the recommended car for the client. 1. You determine the down payment. 2. Determine what your bank loan will be. 3. Calculate the interest rate and make sure the Rate is described and displayed when you format your assignment. DO NOT USE an Internet purchase calculator. This MUST be calculated in Excel. 4. Calculate what you monthly payment would be if the loan was amortized over the following terms. a. 2.5 years b. 5 ye I c. 8 years 5. You must display all (Monthly) Calculations in your workbook. 6. Provide 3 different car options to your client to select from. 7. You can use the same Rate for all 3 car calculations. 8. Use the bank's prime rate of 4.25% as your base Prime Rate. Add 1.55% to the Bank's Prime rate to determine the consumer loan Interest Rate. 9. Provide 3 various down payment options. 10. From the 3 possible cars you have provided for your client you are to select one of them as your recommendation. Insert a photograph of the recommended car purchase into your client Excel presentation sheets. 11. Provide a brief description of the car. 12. Invoice this client just for your services. 13. Use an Excel Invoice Template "Simple Invoice" included in the Moodle File to bill your
Expert Answer:
Answer rating: 100% (QA)
Despite the fact that driving can be fun especially when in the drivers seat of premium extravagance and sports vehicles some of the time you simply need to kick back unwind and have another person dr... View the full answer
Related Book For
Posted Date:
Students also viewed these accounting questions
-
Your client, Casey Farber, is the CEO of a publicly traded corporation. This year, her compensation consisted of $600,000 in cash and $600,000 of stock. The stock received was part of a restricted...
-
The following comment was made by the CEO of a company that recently implemented the Balanced Scorecard: Responsibility in a strategic-based performance management system differs on the three Ds:...
-
The following comment was made by the CEO of a company that recently implemented the Balanced Scorecard: Responsibility in a strategic-based performance management system differs on the three Ds:...
-
A 30-year maturity bond making annual coupon payments with a coupon rate of 12% has duration of 11.54 years and convexity of 192.4. The bond currently sells at a yield to maturity of 8%. Use a...
-
Selected transactions completed by Canyon Ferry Boating Corporation during the current fiscal year are as follows: Jan. 8. Split the common stock 2 for 1 and reduced the par from $80 to $40 per...
-
Use the graph of the rate of change to sketch a graph of the function, starting from the given initial condition. Start from z(0) = 2. 50515253 Ippp
-
Use the summary statistics in Exercise 11 to test the null hypothesis H0: 1 = 0 versus H1: 1 0. Use the = 0.01 level of significance.
-
An experiment was conducted on a new model of a particular make of an automobile to determine the stopping distance at various speeds. The following data were recorded. (a) Fit a multiple regression...
-
19. How would you cut a doubled napped cone with a plane to produce the following. a) a circle b) an ellipse 1 mark 1 mark c) a hyperbola d) a parabola 1 mark Page 11 of 11 1 mark
-
Following is the unadjusted trial balance for Alcorn Institute as of December 31, 2011, which initially records prepaid expenses and unearned revenues in balance sheet accounts. The Institute...
-
design and present a DBS to track students attending classes a CSC class that has a maximum of 21 students and meets 32 times a term. I need to be able to generate 3 reports as follows: 1. A roster...
-
Choose the best statement. A. A subsidy to peanut growers lowers peanut growers costs, lowers the market price of peanuts, and increases the demand for peanuts. B. A price support for peanut growers...
-
To avoid possible duplicated records being inserted into a database, the Insert button on a Frame Form should be enabled after a desired record has been inserted. (True/False)
-
The so-called implicit objects in JSP are objects that are automatically available in JSP because they are automatically instantiated as the project runs. (True/False)
-
To separate presentation and business logic, we can use pages to present our GUI and the to store our data to perform business-related logic. a. HTML, Java help class b. XML, JSF pages c. JSP, Java...
-
A object, which contains all pieces of necessary information about the returned data stored in a ResultSet instance, is returned when the method is executed. a. getMetaData(), ResultSetMetaData b....
-
Which one of the following correctly states a basic feature of the IRC special valuation rules? A) They apply to any intrafamily transfer of assets for which there is no established market if the...
-
Suppose that the electrical potential at the point (x, y, z) is E(x, y, z) = x + y - 2z. What is the direction of the acceleration at the point (1,3,2)?
-
Cleary Industries manufactures three models of a product in a single plant with two departments: Cutting and Assembly. The company has estimated costs for each of the three product models, which...
-
One subunit of Atlantic Sports Manufacturing Company had the following financial results last month: Requirements 1. Complete the performance evaluation report for this subunit (round to four...
-
Hupley manufacturing had a 1.60 operating leverage factor when sales were $ 45,000. Hupley Manufacturings contribution margin ratio was 20%. What were the companys fixed expenses?
-
Calculate the CGT payable in relation to each of the following disposals, assuming in each case that the annual exemption is fully utilised against other gains, that there are no allowable losses and...
-
In October 2012, Matthew bought a piece of rare porcelain for 10,000. The porcelain was damaged in early 2019 and in February of that year Matthew spent 3,850 on restoration work. In July 2019,...
-
Mick Stone disposed of the following assets during tax year 2023-24: (1) On 19 May 2023, Mick sold a freehold warehouse for 522,000. This warehouse was purchased on 6 August 2011 for 258,000, and was...
Study smarter with the SolutionInn App