Given below is the spreadsheet model for an automobile rental.To better understand and mitigate the inherent risk existing in the model,identify the uncertain variable to which assumptions can be defined using Crystal Ball.
The price-demand elasticities of demand are the only estimates and most likely are quite uncertain.Hence,Elasticity is the uncertain variable which can be modeled by uniform distribution using Crystal Ball.
VW
Answered
The purchaser of a 168 day T-bill with a face value of $100,000 paid $97,320.00 for it. After 60 days, interest rates had increased and she sold the T-bill for $97,833.95. What simple interest rate of return per annum did she realize while holding the T-bill?
Sam borrowed $10,000 at prime + 2% on March 29. He agreed to payments of $2,000 on the first day of each month beginning May 1. The prime rate was 4% when Sam took out the loan. Construct a full repayment schedule showing details of the allocation of each payment to interest and principal. What is the final payment?