Question

In order to start a coffee business, the Manager took a 300K loan from the bank....

In order to start a coffee business, the Manager took a 300K loan from the bank. He/she will have to pay 10K monthly for three years.

a-Calculate the effective interest rate (per year). SOLVE BY HAND NOT SPREADSHEET

b-If the coffee business makes a Revenue=19K/month and has an operational cost of 12K/Month, Calculate the PW if the study period is 5 years and the MARR is equal to 1.5% per month. Solve by either Spreadsheet or Hand,

Please Specify in which cells you put which formula.

Homework Answers

Know the answer?
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Not the answer you're looking for?
Ask your own homework help question
Similar Questions
Gerald has taken out a loan of $100,000 today to start a business. He has agreed...
Gerald has taken out a loan of $100,000 today to start a business. He has agreed to repay the loan on the following terms: • Repayments will be made on a monthly basis. The first repayment will be made exactly one month from today. • The repayments for the first 5 years will cover interest only to help reduce the financial burden for Gerald’s business at the start. • After the 5-year interest-only period, Gerald will make level monthly payments...
Gerald has taken out a loan of $100,000 today to start a business. He has agreed...
Gerald has taken out a loan of $100,000 today to start a business. He has agreed to repay the loan on the following terms: • Repayments will be made on a monthly basis. The first repayment will be made exactly one month from today. • The repayments for the first 5 years will cover interest only to help reduce the financial burden for Gerald’s business at the start. • After the 5-year interest-only period, Gerald will make level monthly payments...
Gerald has taken out a loan of $100,000 today to start a business. He has agreed...
Gerald has taken out a loan of $100,000 today to start a business. He has agreed to repay the loan on the following terms: • Repayments will be made on a monthly basis. The first repayment will be made exactly one month from today. • The repayments for the first 5 years will cover interest only to help reduce the financial burden for Gerald's business at the start. • After the 5-year interest-only period, Gerald will make level monthly payments...
Mini-Case Analysis 2: Excel Hydro Inc. Excel Hydro took a loan contract which requires a payment...
Mini-Case Analysis 2: Excel Hydro Inc. Excel Hydro took a loan contract which requires a payment of $40 million plus interest two years after the contract's date of issue. The interest rate on the $40 million face value is 9.6% compounded quarterly. Before the maturity date, the original lender sold the contract to a pension fund for $43 million. The sale price was based on a discount rate of 8.5% compounded semi-annually from the date of sale. Excel Hydro is...
Business Description Daisy, a friend who is an excellent baker, has decided to open a cupcake...
Business Description Daisy, a friend who is an excellent baker, has decided to open a cupcake store to sell gourmet cupcakes. Daisy has asked you if you will be willing to loan the company $50,000 at an interest rate of 4% that will be paid back over 5 years. Using the skills you have developed in ACCT 551 Accounting for Managers, you will analyze the business to determine if you will loan Daisy the money. The business is scheduled to...
Prosperity Land Ltd (PLL) is a commercial property developer. It designs and builds malls for customers...
Prosperity Land Ltd (PLL) is a commercial property developer. It designs and builds malls for customers to operate their businesses. Instead of renting the space to the customers, PLL sells the units to them under Strata Title. PLL needs to determine the right selling prices which allows it to maximise profit while attracting many buyers. This assignment requires you to practise principles of correct spreadsheet construction and design to help PLL to improve its decision making to meet its business...
You are the manager of a U.S. company situated in Los Angeles and manages the import/export...
You are the manager of a U.S. company situated in Los Angeles and manages the import/export division of the company. The company distributes (resells) a variety of consumer products imported to the U.S.A from Europe and also exports goods manufactured in the U.S.A. to Canada. Therefore, your company is very much dependent on the impact of current and future exchange rates on the performance of the company. Scenario 1: You have to estimate the expected exchange rates between your home...
This case assignment draws from the Business Information Systems and the Systems Acquisition and Development modules...
This case assignment draws from the Business Information Systems and the Systems Acquisition and Development modules (Chapters 5 to 8). Its purpose is to provide you with experience in analyzing organizational information systems, making recommendations to improve these systems, and formulating a plan to execute on your recommendations. 1. Recommend one of your alternatives that is the best solution to the main issue and justify your recommendation. Your justification should be based on the key decision criteria and you must...
Sign In INNOVATION Deep Change: How Operational Innovation Can Transform Your Company by Michael Hammer From...
Sign In INNOVATION Deep Change: How Operational Innovation Can Transform Your Company by Michael Hammer From the April 2004 Issue Save Share 8.95 In 1991, Progressive Insurance, an automobile insurer based in Mayfield Village, Ohio, had approximately $1.3 billion in sales. By 2002, that figure had grown to $9.5 billion. What fashionable strategies did Progressive employ to achieve sevenfold growth in just over a decade? Was it positioned in a high-growth industry? Hardly. Auto insurance is a mature, 100-year-old industry...
About John Daniels Chemicals Inc. This business case is about John Daniels Chemicals Inc., which is...
About John Daniels Chemicals Inc. This business case is about John Daniels Chemicals Inc., which is one the most respected and elite chemical research organization in the industry, operating since 1991, with the headquarters in Tanzania, Africa. Organizational Structure and Culture at John Daniels Chemicals Inc. Organizational culture in John Daniels Chemicals Inc. is an open and less rigid one, unlike the other usual corporations in the market. The scientists selected to work in John Daniels Chemicals Inc. are top...
ADVERTISEMENT
Need Online Homework Help?

Get Answers For Free
Most questions answered within 1 hours.

Ask a Question
ADVERTISEMENT