Reference no: EM132068137
Spreadsheet Project Task
Today is 1 January 2018. MQU bank is offering a 5 year $100,000 loan product to its customers.
This loan product requires customers to make monthly repayment. Payment will be paid at the beginning of each month with an amount of $2,000. Use theGoal Seekto find the implied annual nominal rate of interest payable monthly (i.e.,j12) charged by MQU bank.
For this loan product, each customer needs to pay an initial cost of $200 at the beginning of the loan. Use theGoal Seekto find the real borrowing cost for a customer (expressed as an annual rate payable monthly j12). This loan product requires customers to make monthly repayment. The payment will be paid at the beginning of each month with an amount of $2,000.
Assume that customers also have the yearly, half yearly and quarterly payment options. Using these options, customers are required to have payment at the end of each period (i.e., at end of each year, half-year and quarter). Assume that the MQU bank charges an annual nominal rate of interestj1= 7.5% p.a. for these payment options. Find the customer's quarterly, half yearly and yearly payment amount. Use a bar or column chart to plot the quarterly, half yearly and yearly payment amount.
The deadline for Spreadsheet Project Task 1 submission isApril 6th 2018, 9:00AM. Present your answers to the above questions in a functional Excel spread- sheet (it should be a XLSX or XLS file), giving each solution on a separate sheet (labelled Part a, Part b, and Part c).
Your spreadsheet should be clearly labelled and easy to understand. Make sure you identify what the inputs and outputs are. Please include the necessary information e.g., title, axis titles, etc., in your plot.
Please document and describe your working steps. Please note that uploading a file can take up to 10 or 15 minutes. You need to submit your file at least 20 minutes before the deadline to ensure a successful submission.
|
Identify one risk that would not fit traditional definitions
: Identify one risk that would not fit traditional definitions of insurable risks (your example could be for a specific exposure or an organization).
|
|
Find what was the arithmetic average return on each stock
: The rate of return on Cherry Jalopies, Inc., stock over the last five years was 17 percent, 11 percent,-2 percent, 7 percent, and 10 percent.
|
|
Develop vision and mission statements for the organization
: Identify the firm's existing vision, mission, objectives, and strategies.Develop vision and mission statements for the organization.
|
|
Compute the variances for cherry and straw
: Calculate the variances and the standard deviations for Cherry and Straw. (Enter variance as a decimal and standard deviation as a percent.
|
|
Fnd the customers quarterly and half yearly amount
: ssume that the MQU bank charges an annual nominal rate of interestj1= 7.5% p.a. for these payment options.
|
|
What is the project average accounting return
: You're trying to determine whether to expand your business by building a new manufacturing plant. The plant has an installation cost of $11.7 million.
|
|
How is marginal analysis used in price and output decisions
: Identify a firm for each of these market structures and explain why each firm belongs in the market structure identified - How is marginal analysis used
|
|
What was the arithmetic average return on each stock
: The rate of return on Cherry Jalopies, Inc., stock over the last five years was 18 percent, 11 percent, -2 percent, 2 percent, and 15 percent.
|
|
What will be the adjusted total cash flow of machining tool
: You're evaluating the proposed acquisition of a new machining tool for $88,000 by your company. The tool falls into the MACRS three-year class.
|