The Center for Business Analytics is considering a refund policy for no-shows. No refund would be given for members who do not attend, but for nonmembers who do not attend, 50% of the price will be refunded. Build a spreadsheet model in Excel that calculates a profit or loss based on the number of nonmember registrants. Extend the model you developed for the Business Intelligence Symposium to account for the fact that historically, 25% of members who registered do not show and 10% of registered nonmembers do not attend. The center pays the caterer for breakfast and lunch based on the number of registrants (not the number of attendees). However, the center only pays for parking for those who attend. What is the profit if each corporate member registers their full allotment of tickets and 127 nonmembers register? If required, round your answers to two decimal places.

Gulliver travel agencies thinks interest rates in europe are low. the firm borrows euros at 5 percent for one year. during this time period the dollar falls 11 percent against the euro. what is the effective interest rate on the loan for one year? (consider the 11 percent fall in the value of the dollar as well as the interest payment.)

Garcia industries has sales of $200,000 and accounts receivable of $18,500, and it gives its customers 25 days to pay. the industry average dso is 27 days, based on a 365-day year. if the company changes its credit and collection policy sufficiently to cause its dso to fall to the industry average, and if it earns 8.0% on any cash freed-up by this change, how would that affect its net income, assuming other things are held constant? a. $241.45b. $254.16c. $267.54d. $281.62e. $296.44

Ido not understand this project overview agricultural commodities are bought and sold through the stock exchange. the price of commodities changes all the time. investors buy many agricultural commodities before they are ready for shipping. when an investor buys an agricultural commodity that is going to be ready in the future, they call this purchasing futures. this might be a future crop, meat that has not yet been processed, or another type of agricultural commodity. for this project, you will have to decide how to spend $10,000. research the new york stock exchange. find one or more agricultural commodities that you are interested in. remember, it may be listed as a future crop. instructions identify the agricultural commodities that you think have the best chance of going up in price. think about what is going on with supply and demand. decide how you will spend your money. you may purchase only agricultural commodities. check the market every day for a week. record the price of your commodity or commodities each day. you may buy or sell your commodities at any time during the week. you may sell your commodities and buy different ones. feel free to experiment with the $10,000 by buying and selling commodities, but make sure to keep a careful record of your activities. at the end of the week, you will write a report on your investments. this report should be structured to include this information: page 1: explain how the stock market works. page 2: list all commodities purchased. describe each in detail. discuss why you selected these commodities. remember, they must be agricultural. page 3: create a chart or graph to illustrate the price of your commodity or commodities over the week’s time. list all of your activity buying and selling. make sure you include prices and details. page 4: write a summary of your experience. describe what you might do differently if you were using actual money. propose potential reasons why the price of each commodity may go up or down.