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...
1) Jens just took out a loan from the bank for 79,702 dollars. He plans to...
1) Jens just took out a loan from the bank for 79,702 dollars. He plans to repay this loan by making a special payment to the bank of 4,130 dollars in 4 years and by also making equal, regular annual payments of X for 8 years. If the interest rate on the loan is 12.57 percent per year and he makes his first regular annual payment in 1 year, then what is X, Jens’s regular annual payment? 2) Theo just...
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...
Mini Case 2: Excel Hydro Inc. Unit 8 (6% of the grade) Excel Hydro took a...
Mini Case 2: Excel Hydro Inc. Unit 8 (6% of the grade) 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...
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...
Please read the article and answear about questions. Determining the Value of the Business After you...
Please read the article and answear about questions. Determining the Value of the Business After you have completed a thorough and exacting investigation, you need to analyze all the infor- mation you have gathered. This is the time to consult with your business, financial, and legal advis- ers to arrive at an estimate of the value of the business. Outside advisers are impartial and are more likely to see the bad things about the business than are you. You should...
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...
ADVERTISEMENT
Need Online Homework Help?

Get Answers For Free
Most questions answered within 1 hours.

Ask a Question
ADVERTISEMENT