Answered step by step
Verified Expert Solution
Question
1 Approved Answer
The Town of Ticino Faces Bankruptcy Imagine getting a bill for $ 1 2 5 billion that you did not know you owed! The case
The Town of Ticino Faces Bankruptcy
Imagine getting a bill for $ billion that you did not know you owed! The case involves a realworld situation. That happened to the residents, called burghers of Ticino, Switzerland. The New York Supreme Court in Brooklyn, New York, ordered Ticino to pay a group of American investors. The investors had sued in the Brooklyn court over a loss they claimed concerning the failure years earlier of InterChange Bank, a tiny bank in Ticino. The burghers had known about the suit but thought the matter was trivial and were naturally stunned by the bill. Their lead lawyer quipped that if the judgment were upheld by the higher courts, all of Ticinos citizens would have to spend the rest of their lives flipping real burgers the kind you eat at McDonalds and Burger King to pay off the debt.
The root of Ticinos problem was a deposit made years ago, one year before the bank failed. The estate of one Sterling Granville Higgins deposited $ million of options on Venezuelan oil and mineral deposits in the InterChange Bank. The bank agreed to pay an interest rate of per week. No wonder the bank failed the next year! The Brooklyn court ruled that Ticino had to pay interest per week compounded weekly for the seven years between the date of deposit and the date Ticino had the bank liquidated and interest at the rate of APY for the remaining years since the banks liquidation.
Case Questions:
The $ billion reported in the press was rounded, but the original amount was precisely $ million. Assuming the time periods are exactly seven years at a periodic interest rate of per week and exactly years at APY, how much was the bill to the nearest dollar?
For simplicity and convenience, please use $ billion as the amount owed bill for questions # # below:
What is the APY over the entire years as the $ million grows to the amount owed?
Suppose Ticino could pay $ billion per year. How long would it take to pay off the amount owed, assuming interest continued to be charged at APY? Assume annual payments begin one year from the date the amount is owed.
Suppose Ticino could pay $ billion per year. How long would it take to pay off the amount owed, assuming interest continued to be charged at APY? Assume annual payments begin one year from the date the amount is owed.
Suppose Ticino decides to pay the amount owed by making annual payments at APY. What is the annual payment amount if the first payment begins immediately from the date the amount is owed?
Suppose Ticino decides to pay the amount owed by making annual payments at APY. What is the amount of the annual payment if the first payment begins three months after the date the amount is owed?
Please answer ALL the questions in Excel using its builtin financial functions. OR SHOW ALL STEPS NEEDED TO COMPLETE IN EXCEL
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started